Luca, Thanks for the reply, yes that will return the correct results. However the orientdb way seem to be to use quite a few sub queries (correct me if I'm wrong), so just having the top level EXPLAINed means that its really hard to profile queries until it hits an environment with a large amount of data.
This was why I originally raised it in github issues because I assumed it was a bug. From what you say I'm guessing its a not, but is there any work arounds to get those sort of metrics? Thanks, Jamie Hi Jamie, What about the result of: EXPLAIN select from Vertex I think the profiler doesn't collect metrics from sub-queries. Lvc@ On 4 March 2015 at 14:20, Jamie Blair <[email protected]> wrote: > Given the query > > EXPLAIN select from (select from Vertex) LIMIT 1 > > I get the results > > elapsed: 2514.5999 > recordReads: 1 > documentReads: 1 > resultSize: 1 > evaluated: 1 > > Given the query took 2.5seconds I would have expected some of those > numbers to be a lot higher (recordReads, documentReads, resultSize, > evaluated) > > Anyone any idea whats going on? Given the issues with the query > parser/optimiser I really need some data about whats going on with my > queries before they hit production. > > Thanks, > Jamie > > -- > > --- > 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 a topic in the Google Groups "OrientDB" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/BSuiP8a9nqQ/unsubscribe. To unsubscribe from this group and all its topics, 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.
