Hello Jaap,
On Sep 25, 2008, at 20:25 , Jaap van der Plas wrote:
We like to build a database with approx. 50.000 documents. Every
document has at least about 10 fields. We think CouchDB would be nice
solution because there's a big variety of documents (like different
fields).
I'd agree on the assessment that CouchDB is a good fit here.
We intend to use this for an online catelog. We like end users to be
able to search with multiple fields (like filters). Any combination of
fields should be possible.
1. Is this possible to do this without creating temp_views for every
query?
If you want to do fulltext search, I'd second Ayende's suggestion of
using the external search API to let Lucene do this kind of indexing and
searching.
Views can get you there if you create a comprehensive index of all
fields
and all their combinations (possible, probably not nice) and allow for
a keyword search. You could even split up your filter words and put
single
chars, tuples and so on into the index to fake fulltext search. This
is possible
but probably not the most elegant solution.
2. If not, is using temp_views viable performance wise on this sort of
dataset.
Using temp views is not wise unless you want to test view function
definitions
on rather little data. A production system should not rely on them.
(This is
again, a rule of thumb, but with a pretty big thumb!)
Cheers
Jan
--
