Hi,
Counting all the edges of a type it's pretty fast. Try with:
select in('couponlikes').size() as len from coupons where coupon_status=1
order by len desc
Lvc@
ᐧ
On 8 September 2014 15:39, 'Curtis Mosters' via OrientDB <
[email protected]> wrote:
> I have a very similar question I need to count the number of edges to
> choose the Persons with the most outgoing Edges. Can I do this without
> indexing or would it be too slow on 50 Mio entries?
>
> How would a query look like? Thanks.
>
> Am Montag, 8. September 2014 15:11:40 UTC+2 schrieb jaya raj:
>
>> hi,
>>
>> I want to retrieve data using order by query using size of in coming
>> edges
>>
>> *query*
>>
>> select in_couponlikes.size() as len from coupons where coupon_status=1
>> order by in_couponlikes.size() desc
>>
>> but this query not working no effects in order
>>
> --
>
> ---
> 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.
>
--
---
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.
