On Oct 7, 2009, at 5:05 PM, Mike Leddy wrote:
Hi all,
I have a database with approx 100 million records that I like to port
to a couchdb cluster. The documents that will be inserted will
vary between 150-250 fields each.
(I will be doing some cool/complex stuff with views for recently
inserted data in the 24-48 hour range)
A series of historical reports are generated from this data that
are selected using a simple criterion ie. an interval in time
together with multiple locations BUT the fields that are used vary
significantly depending on the reports (and combination of reports)
that are generated simultaneously.
If I were to use views for each report wouldn't I be building a
index plus the resulting field values for each possible report
on disk ?
If I use only one view I will save disk but returning the full
documents via HTTP which will be impractically slow :-(
Is there any way I can have one index being used but filter the
fields being returned in the documents ? I guess conceptually its
single 'view' combined with different 'shows' that return JSON.
Have I missed some obvious way to do this ?
TIA
Mike
Hi Mike, I think you're right, the way to accomplish this is to write
multiple 'list' functions that send different subsets of the value
stored in your view. The API for _list is quite different in 0.9 and
0.10, see
http://wiki.apache.org/couchdb/Formatting_with_Show_and_List
Best, Adam
