At 19/10/2002 17:17, Ed Carp wrote: > 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.
Sorry Ed, but I disagree. I'm almost sure it's a MySQL problem. I tried the SAME code with the SAME table structure under SQL Server and it reported an opening and closing time close to 0 seconds. I looked for something like dbSQLPassThough but I found nothing :(((( Thanks, Massimo ----------------------------------------------------- This mail sent through IMP: http://web.horde.org/imp/ --------------------------------------------------------------------- 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