Hi All; I have been writing a VB app that has been very quick and responsive across the DSL modem connection I have to the server. Yesterday I populated the tables with about 100,000 rows, and then I started having a problem: When I run a query through a SSH session to the server, the query is reported at 0.02 seconds, and returns 5 rows very quickly (the appropriate index is in place), but when I run the query through ODBC on my VB client, it takes 10 seconds. Any ideas on what is causeing the discrepancy?
Mike --------------------------------------------------------------------- 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
