Hi,
I am new to Orient DB.
Following are the structure for my Orient DB environment
vertex class
1. Customers class extends V (With having 50,000)
2. Order class extends V (With having 5,000,00)
3. OrderDetails class extends V (With having 10,000,00)
Edge Class
1.custorderedge class extend E( With having 5,000,00)
1.orddetailsedge class extend E( With having 10,000,00)
All are vertex having the index.
When i query below one
1. select sum(out('custorderedge').out('orddetailsedge').rate) as Sum_Rate
from Customers where customerId <= 20000 ==> Its taking 13.44 Seconds
2. select sum(rate) from OrderDetails ==> Its taking 33.43 Seconds
Can anyone suggest me for better way to query above aggregation to get
results in milliseconds.
Thanks
Prakash Hosalli
--
---
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.
