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.
