Hi,
I am using OrientDB v.1.7.8, and a Task table with indices as following
and my query is
"
SELECT FROM Task
WHERE (((DueTime <= '2015-12-28 09:33:02') AND (Status = 0)) OR
((ProcessId = 1) AND (Status = 10))) AND (EntityInfo.State = 0)
ORDER BY Priority DESC, DueTime DESC, @rid ASC limit 200
"
(I am using named parameters)
when the Task table contains no row, the query is really fast (about 0.0002
second)
but when it contains around 2k rows, the query is slower (about 0.4 seconds)
and when it contains more than 200k rows, the query takes *11+ seconds*
with 0 rows in returning.
How should I index the table to get the best performance for the query
above?
Any idea will be really appreciated!
My Best,
Hung Tran
--
---
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.
