Hi, I am running OrientDB version 2.1.8, I running into the performance issue with this SQL
SELECT Statistics, $activeContacts[0].count FROM (SELECT FROM ContactList WHERE Account=#20:0 AND EntityInfo.State=0) LET $activeContacts = (SELECT count(*) FROM Contact WHERE OwnedBy = $parent.$current AND Status = 0) I have tried to break it down, each part individual SQL is fast, but a combination is pretty slow, I read its explain, but not sure what causes this. The ContactList table has only 3 records, and Contact table has about 50k records. Any suggestion will be very appreciated! My Best, Hung Tran -- --- 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.
