On Sat, Jun 20, 2009 at 12:49 AM, hhsuper<[email protected]> wrote: > Thanks Jan, > > when i need to paginate the data queried from view, you mean the sorting and > paginating should all outside the couchdb?
Sorting by value is mathematically tough, if you want to read more about the underlying issues check out http://labs.google.com/papers/sawzall.html If you can live with the sorted order being out of date, the simplest thing to do is copy the results of a group=true query to another database (via a scripting language like ruby or python) and then use a view to sort those results by value. It won't be incrementally updated as records are updated in the original database, but it will give you an exact ordering by value. We are thinking of building something like this into CouchDB because it is such a common query, but for now you've got to do it yourself. Chris > > On Sat, Jun 20, 2009 at 3:39 PM, Jan Lehnardt <[email protected]> wrote: > >> >> On 20 Jun 2009, at 03:05, hhsuper wrote: >> >> Hi, >>> >>> i have a view (impl with map/reduce function), the value need to be >>> caculated in reduce function(for group reason etc.), and then how could i >>> sorting by the value column? >>> >> >> You need to sort by value outside of CouchDB. >> >> Cheers >> Jan >> -- >> >> >> > > > -- > Yours sincerely > > Jack Su > -- Chris Anderson http://jchrisa.net http://couch.io
