UPDATE Statistics
SET NumActiveContacts = $activeContacts.size(),
NumContacts = $totalContacts.size()
LET $activeContacts = (SELECT FROM Contact
WHERE (Account=#20:0
AND OwnedBy.Statistics=$parent.$current
AND Status=0
AND OwnedBy.EntityInfo.State<>200)
AND EntityInfo.State=0),
$totalContacts = (SELECT FROM Contact
WHERE (Account=#20:0
AND OwnedBy.Statistics=$parent.$current
AND OwnedBy.EntityInfo.State<>200)
AND EntityInfo.State=0)
WHERE @rid IN (SELECT Statistics FROM ContactList WHERE Account=#20:0 AND EntityInfo.State=0)
Hi,I am running on OrientDB v1.7.8, here is my Update SQL
UPDATE Statistics
SET NumActiveContacts = $activeContacts.size(),
NumContacts = $totalContacts.size()
LET $activeContacts = (SELECT FROM Contact
WHERE (Account=#20:0
AND OwnedBy.Statistics=$parent.$current
AND Status=0
AND OwnedBy.EntityInfo.State<>200)
AND EntityInfo.State=0),
$totalContacts = (SELECT FROM Contact
WHERE (Account=#20:0
AND OwnedBy.Statistics=$parent.$current
AND OwnedBy.EntityInfo.State<>200)
AND EntityInfo.State=0)
WHERE @rid IN (SELECT Statistics FROM ContactList WHERE Account=#20:0 AND EntityInfo.State=0)
it's working with table less than 10k rows, and it keep running more than 24+ hours to update at 100% CPU for OrientDB-1_7 process when my Statistics table is about 200k rows. Remarks, the Update above will only need to update 10k rows.
Indices on Contact tableIndices on ContactList table
Any help will be really 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 orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.