[ 
https://issues.apache.org/jira/browse/COUCHDB-1960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13846850#comment-13846850
 ] 

Russell Branca commented on COUCHDB-1960:
-----------------------------------------

I didn't spend much time optimizing the _all_dbs pagination because as Newson 
mentioned in the other thread, it's doing a file system scan and returning all 
the items. So if you have tens of thousands of databases, let alone millions, 
you're going to be hosed either way. Although admittedly, making an additional 
request per database doesn't help matters. When BigCouch is merged, the list of 
databases will be represented in a database, and we will be able to do the 
standard pagination queries on _all_dbs.

> Provide pagination for /_all_dbs
> --------------------------------
>
>                 Key: COUCHDB-1960
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-1960
>             Project: CouchDB
>          Issue Type: Improvement
>          Components: Fauxton, HTTP Interface
>            Reporter: Benjamin Young
>
> The database-per-user design pattern has increased in popularity and 
> consequently causes long lists of databases when one hits {{/_all_dbs}}
> To keep this sane, we need some pagination.
> {{?skip=10&limit=10}} style seems to be the simplest to implement (and there 
> should be existing code from Cloudant for this one).
> Thanks!



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Reply via email to