I'm very new to mysql. I wonder how good is mysql, and comparing it to
MS Access. I know mysql is supposed to be way faster than Access,
however, to my surprise, it's not necessary the case.
I have a table with 700K records. I issued these 2 queries:
Access:
select top 300000 * from rawdata
mysql:
select * from rawdata limit 1,300000
It seemed to me that Access return the result set faster than mysql (at
least 1.5 secs difference). What did I do wrong?
Thanks in advance.
Kevin
---------------------------------------------------------------------
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