i have a table with 10000 records in MS Access and
MySQL with no index in either database.
I query both  tables from ColdFusion using ODBC datasources and

Data from Access took 13sec to display while
Date from MySQL took 23sec to come up

MySQL seems to be half way slow....????
should i use index etc????

comments???



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

Reply via email to