MySQL Forums :: Newbie :: select limit records from 600000 records


Advanced Search

select limit records from 600000 records
Posted by: odelya glick ()
Date: October 30, 2009 06:14AM

hi

i have a table with more than half a million records.

i tried to run select * from video limit 400000,400020;

but it takes it too long.

what is the best way to use limit for many records?

Options: ReplyQuote


Subject Written By Posted
select limit records from 600000 records odelya glick 10/30/2009 06:14AM
Re: select limit records from 600000 records Peter Brawley 10/30/2009 07:44AM
Re: select limit records from 600000 records odelya glick 10/31/2009 02:22PM
Re: select limit records from 600000 records Devart Team 10/30/2009 08:39AM
Re: select limit records from 600000 records Rick James 10/30/2009 08:18PM
Re: select limit records from 600000 records odelya glick 10/31/2009 02:30PM
Re: select limit records from 600000 records Rick James 10/31/2009 02:53PM
Re: select limit records from 600000 records odelya glick 11/02/2009 11:19AM
Re: select limit records from 600000 records Rick James 11/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.