groupedby is really slow

Issue #452 new
David Kendal
created an issue

In my database of 700,000 documents, of which I search for a subset of about 136,000 members, using groupedby slows the query down from 5–10 seconds to around 30.

I think this is because of the lack of caching mapping document ids to group ids — if I get all results at once and cache the groupings, and do the caching myself in memory, it goes back down to 5 or 10 seconds to retrieve and group the whole lot of 135,000 documents after the initial run builds the cache.

Comments (1)

  1. Log in to comment