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.
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.