incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Samuel Newson <rnew...@apache.org>
Subject Re: Regarding "Skip as fast as startkey"
Date Tue, 01 Apr 2014 14:15:38 GMT
Ah, good reminder. Yes, it’s not true, several people have performed the timings and confirmed
that skip (while faster than it was) is not as fast as using the right startkey.

B.

On 1 Apr 2014, at 15:12, Daniel Wertheim <daniel@wertheim.se> wrote:

> Was looking at this: https://issues.apache.org/jira/browse/COUCHDB-1076
> 
> Which in the final comment states: "As far as I'm aware, skip is
> equivalently fast to a startkey search"
> 
> Glanced at the latest documentation, which has this pre v.1.2 vs after
> v1.2:
> http://couchdb.readthedocs.org/en/latest/couchapp/views/pagination.html
> 
> Did a quick test with 1.700.543  docs. CouchDb v1.5 Windows. Key is an
> integer from 1 to 1.700.543
> 
> 13000ms for limit=10&skip=500000
> 48ms with startkey, startkeydocid, skip, limit
> 
> Seems to me that the documents should still say "Don't use this" or what am
> I missing?
> 
> //Daniel


Mime
View raw message