|
Post by victorh on May 16, 2019 5:16:53 GMT -5
My CR8 installation is quite fast for records less than 10000. I have database of 44000 records and the CR8 searches are very slow. What can I do to improve my search speed? I have indexed my search columns in the database already. I am using MySQL.
|
|
|
Post by Allan Murray on May 17, 2019 4:25:04 GMT -5
The built-in search function may be slow with large databases, as it is a brute-force search.
A faster method may be to use a SQL select string when connecting to the database (either to find a single record, or to narrow down the selection before using the built-in search).
See Database/SQL select and formatting strings in the manual.
Basically you can enter something like: TABLE1 WHERE NAME='JOE' in the select string box of database properties before connecting to the database (instead of just entering TABLE1).
This should be much faster as the search is done by the ODBC driver rather than by the software.
|
|
|
Post by victorh on May 17, 2019 14:36:10 GMT -5
Thanks.
We are printing cards for members and these members come in any order, and the users are not really the computer savvy. How difficult would it be to actually send a query directly to the database through the ODBC connector? This is a very useful application, it would be good if you could solve the search speed issue without having disconnect and reconnect to the database all the time even it means we pay a bit more for it.
|
|