It would help if we knew the format of the customerId field. From the
(limited) information given we must suppose that customerId is simply a
number from 1 to number of records.
if this *is* the case, then your query is invoking a sum function on every
order for every customer. Is this what you are trying to do?
On Tuesday, 28 July 2015 12:28:14 UTC+1, Prakash Hosalli wrote:
>
>
>
> Hi,
>
>
> I am new to the OrientDB.
>
>
> I created 4 nodes on four different VM'S.
> orientDB1,orientDB2,orientDB3 AND orientDB4.
>
>
> My environment consists of following things
>
>
> 1. OrientDB Community 2.0.12.
>
> 2. Customers Vertex have 10000 nodes (Index is on Customers.customerId).
>
> 3. Order Vertex have 100000 nodes (Index is on Order.customerId_orderId).
>
> 4. OrderDetails Vertex have 200000 nodes (Index is on
> OrderDetails.orderDetailId_orderId).
>
> 5. custorder1 Edge with no properties.
>
>
>
> Operation :
>
> We trying to have aggregation on this
>
> On studio Console :
>
> 1. select sum(out('custorder1').out('custorder1').rate) from Customers
> where customerId <= 10000 -- Its taking Query executed in 9.848 sec.
> Returned 1 record(s).
>
> Can anyone plz guide me to optimize the the query.
>
>
> Thanks
> Prakash
>
>
--
---
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.
