Hi, I think, the issue is from your SQL, you MUST not enclose the rid value (so the engine tried to cast @rid to string and no index used), try this
SELECT FROM <class> WHERE @rid > #25:1705999 ORDER BY @rid ASC LIMIT 2000 Hope it helps! My Best, Hung Tran On Sunday, February 14, 2016 at 11:21:04 PM UTC+7, Selvaraj chennappan wrote: > > > > 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.
