Luigi? Anyone? On Tuesday, 21 April 2015 16:23:05 UTC+1, cr0xfyre wrote: > > 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]>: >> >>> 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]. >>> 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.
