couchdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mickael Bailly (JIRA)" <j...@apache.org>
Subject [jira] Created: (COUCHDB-812) implement randomization in views resultset
Date Mon, 28 Jun 2010 14:47:50 GMT
implement randomization in views resultset
------------------------------------------

                 Key: COUCHDB-812
                 URL: https://issues.apache.org/jira/browse/COUCHDB-812
             Project: CouchDB
          Issue Type: Wish
          Components: Database Core
    Affects Versions: 0.11
         Environment: CouchDB
            Reporter: Mickael Bailly
            Priority: Minor


This is a proposal for a new feature in CouchDB : allow a randomization of rows in a view
response. We can for example add a randomize query parameter...
This request would probably not return the same results for the same request.

As an example :

GET /db/_design/doc/_view/example :
{
  ..
  rows: [
    {key: 1 ...},
    {key: 2 ...},
    {key: 3 ...}
  ]
}

GET /db/_design/doc/_view/example?randomize=true :
{
  ..
  rows: [
    {key: 2 ...},
    {key: 3 ...},
    {key: 1 ...}
  ]
}

GET /db/_design/doc/_view/example?randomize=true :
{
  ..
  rows: [
    {key: 1 ...},
    {key: 3 ...},
    {key: 2 ...}
  ]
}

This is a feature hard to implement client-side (but by reading all doc ids and use client-side
random function). It's implemented by the RDBMS from ages, probably for the very same reasons
: if we should read all the rows client-side to random-select some of them, performances are
awful.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message