[arangodb-google] Re: Faceted Search Performance

2017-09-18 Thread Jan
Hi, yes, it will scan the collection 4 times with the query below, once for each subquery. Short-term I do not see any way to speed that up with existing AQL. Long-term a few ways to handle this would be to parallelize the scanning or to collect and count the same input by multiple criteria

[arangodb-google] Re: Faceted Search Performance

2017-09-18 Thread Roman Kuzmik
4 seconds per facet, thus adding 3 more it takes us to 16 seconds. btw, why is that, arango is doing full scan anyways. is it doing it 4 times with the query bellow? Is there any way to make it smarter? LET docs = (FOR a IN Asset RETURN a) LET attribute1 = ( FOR a in docs COLLECT attr =

[arangodb-google] Re: Faceted Search Performance

2017-09-18 Thread Roman Kuzmik
compiled your changes from feature/mmfiles-hash-lookup-performance indeed, on single facet we are down to 4 seconds from 6 seconds (in the test case provided above). And no indexes needed. hope it will make to master soon. -- You received this message because you are subscribed to the Google