2

I'm working with huge records amount in one table and i need to SELECT them in 50000 pages. Is it possible somehow to limit these pages so the query would be faster and row count will be limited and offsetted?

I'm using ODBC with php like this:

        $odbc_query = "SELECT * FROM " . $table_name;

        $data = odbc_exec($this->odbc_id, $odbc_query);

        while($row = odbc_fetch_array($data))
        {
Sai Kalyan Kumar Akshinthala
  • 11,704
  • 8
  • 43
  • 67
Petr Velký
  • 371
  • 2
  • 5
  • 16

2 Answers2

7

The limit is possible by FIRST(limit):

SELECT * FROM tablename FIRST(1000);
hynekcer
  • 14,942
  • 6
  • 61
  • 99
1

u can use limit keyword to limit the number of records...

select * from tablename limit 1000;

this will give u first 1000 rows..

now next time u want next thousand for this u have to keep track of ur last position.

so the query becomes...

select * from tablename limit 1000 offset by lastposition;
Arion
  • 31,011
  • 10
  • 70
  • 88
shofee
  • 2,079
  • 13
  • 30