MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: select limit records from 600000 records
Posted by: Peter Brawley
Date: October 30, 2009 07:44AM

LIMIT 400000,400020 has to read 400020 rows. Best to scope with a WHERE clause.

PB
http://www.artfulsoftware.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
select limit records from 600000 records
odelya glick
October 30, 2009 06:14AM
Re: select limit records from 600000 records
Peter Brawley
October 30, 2009 07:44AM
Re: select limit records from 600000 records
odelya glick
October 31, 2009 02:22PM
Re: select limit records from 600000 records
Devart Team
October 30, 2009 08:39AM
Re: select limit records from 600000 records
Rick James
October 30, 2009 08:18PM
Re: select limit records from 600000 records
odelya glick
October 31, 2009 02:30PM
Re: select limit records from 600000 records
Rick James
October 31, 2009 02:53PM
Re: select limit records from 600000 records
odelya glick
November 02, 2009 11:19AM
Re: select limit records from 600000 records
Rick James
November 03, 2009 12:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.