You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to OrientDB
Hi,
I am using OrientDB version 2.1.8.
Remarks, it works when I alias Statistics.NumActiveContacts as v1, but the query will take long on a table > 50k records. See more details at Query is extremely slow when ORDER BY an alias
Any idea will be appreciated!
My Best,
Hung Tran
alessand...@gmail.com
unread,
Jan 28, 2016, 3:24:29 AM1/28/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to OrientDB
Hi,
try this query
select from (select @rid, Statistics.NumActiveContacts from ContactList where (Account = #20:0) and (EntityInfo.State = 0)) order by Statistics asc, @rid asc skip 0 limit 5
Kind regards,
Alessandro
Hung Tran
unread,
Jan 28, 2016, 3:55:51 AM1/28/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to OrientDB
Hi Alessandro,
Thank for your response, it's working, understood the logic.
However, as a result, the query is doing fully cluster scan (verified), so the query performance is just similar to using alias.