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 table
Indices 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
