I have 5 lakhs record in class.
I want to fetch 2000 records and send for processing.
Query :
'SELECT FROM class WHERE @rid > "#-1:-1" ORDER BY @rid ASC LIMIT 2000'
'SELECT FROM class WHERE @rid > "#-1:-1" ORDER BY @rid ASC LIMIT 2000' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index [OProfiler]
How to avoid this waing ?
I have tried with between operator as well . I am getting the same waing.