Hi Madhu, How much heap do you have? Can you try doing an explain? explain select from V where STATE = 'Active' and ICON_TYPE IN [1,2,3,4,5,7] and SEV_INWIN IN [5,4,3,-1,-2] order by SEV_INWIN DESC, ICON_TYPE ASC SKIP 500 LIMIT 300
Lvc@ On 10 April 2014 17:49, madhu <[email protected]> wrote: > Hi Everyone, > > Facing an OOME with order by query execution in the following scenario. > Used orientdb version is latest 1.7-SNAPSHOT > > Total number of records in V: 238680 > Index created on SEV_INWIN property. > Index created on ICON_TYPE property. > > STATE='Active' number of records: 232492 > SEV_INWIN IN [5,4,3,-1,-2] number of records: 226746 > ICON_TYPE IN [1,2,3,4,5,7] number of records: 226746 > Number of records for the query [select count(*) from V where ICON_TYPE IN > [1,2,3,4,5,7] and SEV_INWIN IN [5,4,3,-1,-2] and STATE='Active']: 226746 > > In this scenario, execution of the following query gives OOME. > select from V where STATE = 'Active' and ICON_TYPE IN [1,2,3,4,5,7] and > SEV_INWIN IN [5,4,3,-1,-2] order by SEV_INWIN DESC, ICON_TYPE ASC SKIP 500 > LIMIT 300 > > Can someone give suggestions to resolve this? > > Thanks, > Madhu > > -- > > --- > 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. > -- --- 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.
