What are the challenges you face when working across database platforms? Take the survey
Options

How to read a large table with more than 522 million rows?

I want to select the rows from the range x to y in a MyISAM table. The table description is

CREATE TABLE table_name (column_1 varchar(255) NOT NULL, column_2 varchar(255) NOT NULL, PRIMARY KEY (column_1,column_2)) ENGINE=MyISAM DEFAULT CHARSET=ascii;

For example, I need to select rows from 100000000 to 100001000. I tried using limit with offset but it became too slow after a certain number of rows. How can it be achieved? Could you guys please help?

I tried using limit with offset but it became too slow after a certain number of rows. When the offset was set up to 100 million the query takes more than 7 minutes to complete. I want to make it faster or another solution.

Tagged:
Sign In or Register to comment.