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

**URL:** https://forums.percona.com/t/how-to-read-a-large-table-with-more-than-522-million-rows/19910
**Category:** MySQL & MariaDB
**Created:** [February 3, 2023, 12:42pm UTC](https://forums.percona.com/t/how-to-read-a-large-table-with-more-than-522-million-rows/19910 "2023-02-03T12:42:02Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Sri\_Ram](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sri_ram/32/9156_2.png) [@Sri\_Ram](https://forums.percona.com/u/Sri_Ram)
#### Post date: [February 3, 2023, 12:42pm UTC](https://forums.percona.com/t/how-to-read-a-large-table-with-more-than-522-million-rows/19910/1 "2023-02-03T12:42:02Z")

</div>

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

```auto
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?

---

<div class="post-metadata">

### Author: ![Ankit\_Kapoor1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ankit_kapoor1/32/8977_2.png) [@Ankit\_Kapoor1](https://forums.percona.com/u/Ankit_Kapoor1)
#### Post date: [February 3, 2023, 1:04pm UTC](https://forums.percona.com/t/how-to-read-a-large-table-with-more-than-522-million-rows/19910/2 "2023-02-03T13:04:31Z")

</div>

Hello @Sri_Ram ,

Welcome to Percona and thanks for reaching out.

Can you share what exact query you are trying to execute ?