> On Sep 11, 2014, at 7:56 AM, Eric Benzacar <[email protected]> wrote: > > for large datasets (ex: millions of docs), how efficient > is running everything through a JS compiled view? Each time you open a > view, it needs to filter millions of docs.
No, the map function only runs once on any particular document revision. The view's index is persistent, and a doc only gets re-indexed if it's been changed. So while the first query might be slow due to having to index everything that's already in the database, subsequent queries are fast. (And the 'first-query-slow' problem affects other kinds of databases too, even relational ones.) —Jens
