I have a large data set of over 20k records containing a property named "year". I'm trying to effectively aggregate distinctive data, for example:
select list(distinct(year)) from class This record set takes roughly 1.3 to 1.6 seconds to execute, I presumed that after the initial search the results would be cached and thus, the query times decreased, but it does not appear to be the case. I'm using a document database with the plocal engine, how could I effectively query this data in under a second? -- --- 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.
