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.
