Hi Luigi, I'm looking at the output in the studio itself. Below the result table it says something like: "Query executed in 0.153 sec. Returned 20 record(s)"
Isn't this time correct? if not, how can I see the real query time? On Tuesday, 21 April 2015 13:22:22 UTC+1, Luigi Dell'Aquila wrote: > > Hi cr0xfyre, > > how are you measuring these times? Are you reading the query EXPLAIN? > I ask because this could be just the time Studio takes to render the > results, a query like this should take a few tens milliseconds to execute. > > Luigi > > > 2015-04-21 13:01 GMT+02:00 cr0xfyre <[email protected] <javascript:>>: > >> Hi everyone, >> >> I'm very new to orient (and DBs in general) and I know very little about >> optimizing query speeds. >> My problem right now is that a simple query like >> >> select * from Leaf >> >> is taking the following times, with different limits: >> >> >> - *limit *= *time of query* >> - 500 = ~0.7s >> - 2450 = ~1.5s >> - 3938 (max leafs right now) = ~2.4 s >> >> Some details: I'm running the queries in the studio. Leaf as only 6 >> properties: a name (couple words max), a text (couple paragraphs), 2 >> booleans and 2 dates. Leaf as also a couple different possible edges >> connecting to it. >> >> Isn't this too much time for this simple query, or is it expected? 2.5 >> seconds for only 4000 records seems like a lot when I'm expecting to have >> 50k ou 100k of records in the future... >> >> Now, like I said, I'm very new to this and haven't applied any king of >> optimization to my DB. Is this what indexes are for? how do they work and >> how do I know which to apply? Are there any other ways to speed up queries? >> >> Any help is welcome! >> Thanks! >> cr0xfyre >> >> -- >> >> --- >> 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] <javascript:>. >> 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.
