Hi Luigi, Thanks for the reply. But you're saying there's no way to make this query performant? It seems like a simple query to me, what am I missing?
Thanks, Erik On Monday, February 29, 2016 at 8:27:47 PM UTC+11, Luigi Dell'Aquila wrote: > > Hi Erik, > > Right now there is no support for such use case, you can define an index > on both fields but it will be used only for one of them. > I can think to a hack in 2.2, using a spatial index and doing a 2D spatial > search, but again, it would be a hack. > > Thanks > > Luigi > > > > 2016-02-28 12:43 GMT+01:00 Erik Pragt <[email protected] <javascript:>>: > >> Hi all, >> >> I have a document database with 1.000.000 Persons in it. Persons have a >> name, an age, and number of children. Now I want to find the persons who >> are older than 40 and have more than 3 children. This is taking a long >> time, because there's no index on the Persons table/collection. >> >> What kind of index do I need to create to make this performant? Two >> indexes, one per field? One composite index? Any suggestions would be >> welcome! >> >> Thanks, >> >> Erik >> >> -- >> >> --- >> 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.
