sounds like a map-reduce is what you're looking for. Or, you could emit all the documents, and choose a random row entry on the user end (though that would be poor practice depending on the size of your database etc.)
On Tue, Sep 21, 2010 at 1:27 PM, Peter Braden <[email protected] > wrote: > Hi, > > Is there a good way to get a random document from a database. I'm currently > using a view that does: > > function(doc) { > emit(Math.random(), doc); > }; > > But as this isn't deterministic, I'm pretty sure it's wrong. > > I've done a bit of googling, and haven't found anything. > > Cheers, > > Peter > > > > -- > Peter Braden > > <http://PeterBraden.co.uk/> >
