Application freezes or slows when selecting records with ODBC Database
We have Bartender Designer 2022 and as I'm setting up our ODBC, the time it takes for the application loads can be minutes.
I click print > click Select Records > wait for the program to freeze then load records for a minute > Select the item label to print > click print > wait for the program to freeze and then print after a minute or 2.
With a local Excel sheet, it's instant, with our ODBC database connection it takes awhile.
Is there a way to cache this database and periodically update it?
-
Hey Aaron,
The high latency could result from a number of factors. Here are some things to think about-
What type of database are you connected to? Databases like SQL Server and Oracle have their own connectors in BarTender and do not need an ODBC connection.
How large is the table you are querying? The more data coming back in the initial query, the longer it takes for BarTender to cache locally.
How are you filtering the data that comes back? Query prompts should be relatively fast, as long as auto-complete isn't turned on. If autocomplete is turned on, I have found it can take a very long time as it is bringing back the entire record set at print time every time to populate the autocomplete.
0
请先登录再写评论。
评论
1 条评论