OrientDB - Limit by time or prevent huge queries execution

110 Views Asked by At

Is there a way to limit a query execution by time? I'm familiar with the TIMEOUT clause of a SELECT statement, but I can't seem to find an equivalent for the graph queries, such as MATCH or TRAVERSE.

An alternative for a timeout will be to identify somehow the problematic query and avoid it, but I can't find any EXPLAIN statement to perform without actually perform the query...

The situation is quite problematic as performing 2-3 MATCH queries may explore the whole graph, take forever to complete and only hard-reset releases them.

I've also searched for an option to cancel/interrupt/kill a query but couldn't find it (only via HTTP API).

We're using the JAVA API with version 2.2.30.

Thanks.

0

There are 0 best solutions below