Re: Doing a select on a large table
Yes. I agree with KimSeong.
I suggest to number your rows. For example with an auto_increment primary key.
Then you could SELECT ... WHERE number_column BETWEEN 20000 AND 30000.
Regards
Ingo
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
7530
September 07, 2006 02:04AM
3308
September 07, 2006 06:37AM
3319
September 18, 2006 01:58AM
3298
September 18, 2006 07:00PM
3133
September 18, 2006 08:32PM
Re: Doing a select on a large table
2940
October 05, 2006 02:24PM
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.