Topic: Optimization of heavy request
In the table of a DB about 10 million the records, two indexes.
In a script all table gets over, $st permanently increases on 30000
Select query * FROM table1 JOIN (SELECT id FROM table1 ORDER BY id LIMIT $st, 30000) as b ON b.id = table1.id; it is very long fulfilled. Advise, please, that it is possible to make for its optimization?