Hi Alessandro,
OMG, it gives a better result. 2.5 sec instead.
Look at its explain, I don't know why it is faster.
With that query style, how could I write a similar query like
SELECT Statistics, $active[0].count, $total[0].count FROM ContactList
LET $active = (SELECT count(*) FROM Contact WHERE OwnedBy = $parent.$current
AND Status = 0),
$total = (SELECT count(*) FROM Contact WHERE OwnedBy = $parent.
$current)
WHERE Account=#20:0 AND EntityInfo.State=0
I look forward to hearing from you. Thank you for your concern.
My Best,
Hung Tran
On Friday, January 22, 2016 at 10:39:23 PM UTC+7, [email protected]
wrote:
>
> Hi,
> can you try with this query ?
>
> SELECT OwnedBy[EntityInfo.State=0][Account=#20:0].Statistics, count(*)
> FROM Contact where Status = 0 group by OwnedBy
>
> Best regards,
> Alessandro
>
--
---
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.
