Does mysql do any optimization for then one use `select ... limit x,y`?
For example, I have table with 2000000 records and want to do page web interface to this table. When i use `select ... from table limit 1500000, 20 `, it will need more and more times (on my here is more than 60 sec). well,that is sooooo slowly for the web interface. can any case make it quickly.... help,plz. Thx for all.... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]