> Does anybody know how I can solve this problem? > How can I improve the " opening " performance? > Does MySQL cache something for each records?
It's not a MySQL problem, but a problem how you're opening the recordset. In VB, you would set the DBSQLPassThru flag - I don't know what the equivalent is in Windows C. The problem is that the client is downloading the entire record set and oding the select on the PC when you do the open - that's why it takes longer the bigger your table is. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
