Re: Doing a select on a large table

[Mekin Maheshwari]

I am having the same problem.

I am currently using Mysql 4.1 (Is this behaviour because Mysql 4.1 does not have cursors ?)

Any help would be greatly appreciated.

I do not have any order by or where clauses.

Its a simple select with limit.
select * from ABC limit 0,10000;
select * from ABC limit 10000, 20000;
....