Let me try to answer your questions: 1) I'm not completely sure what you mean. Are you asking if AQL can express such things or if AQL is performant enough?
2) We have customers which much more data and a lot of indexes. If an index is useful depends on your query. But you use the explain command on your queries to decide that. 3) There are different ways to do that. Are your queries to pre-selected Ids going in direction of ranges or are pre-selected Ids independent? Am Donnerstag, 8. September 2016 17:24:03 UTC+2 schrieb Luke Yang: > > We have a design scenario: > 1) 100M+ records in a collection, multiple indexes on records and filters > used for searching the records > 2) Desired Record key or Ids can be pre-selected or determined during the > actual searching > 3) We want to search the final set of record key or Ids based on 2) + > multiple filters (with which indexes are built upon) > > Question: > 1) How good ArangoDB Query can handle this? > 2) Since indexes are built based on 100M+ records (assuming the full > collection), do multiple filters work effectively? What kind of algorithm > is used in the implementation? > 3) Since we have pre-selected Ids for the records, the most effective > approach is to search on this subset of data, does ArangoDB have the > mechanism to do that? > > > -- You received this message because you are subscribed to the Google Groups "ArangoDB" 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.
