I want to fetch 2000 records and send for processing.
When I am fetching record using rid and LIMIT . My query is : 'SELECT FROM <class> WHERE @rid > "#25:1705999" ORDER BY @rid ASC LIMIT 2000' *Below warning :* 'SELECT FROM <Class> WHERE @rid > "#25:1705999" 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] Actually My LIMIT is 2000. How to avoid this warning? I have tried with between operator as well , am getting the same warning. 'SELECT FROM Card WHERE @rid between #25:1706000 and #25:1707999 -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
