Well, it's the only way I figured I could solve my problem. I detailed it in a previous thread named " Map/reduce problem" (02 Jul). I ended up creating a view for each doc.type where the key is simply the data, and that means having lots of views. I didn't know of any limitations concerning the number of views a database can have.
On Wed, Jul 11, 2012 at 1:31 AM, Keith Gable <[email protected]>wrote: > I would want to know why you're creating so many views. Views aren't > queries. I have maybe a dozen and my application is pretty large. > On Jul 10, 2012 7:15 PM, "João Ramos" <[email protected]> wrote: > > > Something is still not right. I increased the filedescriptors to 4096 and > > the same thing keeps happening. > > > > I restarted Couchdb, and used _stats to check how many filedescriptors > were > > open: about 10, so I proceeded in creating 1000 design docs and > > the filedescriptors count went up to about 1000. I inserted another 1000 > > three more times and the count went up as excepted at around 4056. Then I > > queried those views (each design docs has only one view) and everything > was > > fine. The 4000 queries were fast. To make sure I did them again and still > > no problem. Then I tried to insert another 1000 designs docs and the > error > > started showing up. I couldn't use the database for anything anymore. > > > > Then I decided to compact the database and the filedescriptors returned > > back to about 10. So far so good, so I started querying 1000 views and > the > > count went up again. I managed to call up until 4000 different views > until > > the error reappeared. > > > > Does Couchdb ever closes the filedescriptors? Does limit on the number > > of filedescriptors somehow influences the maximum number of design docs / > > views a database can have? > > > > On Mon, Jul 9, 2012 at 9:25 PM, Niels Boldt <[email protected]> > wrote: > > > > > Hi > > > > > > emfile means you run out of filedescriptors > > > > > > See http://wiki.apache.org/couchdb/Performance#Resource_Limits for > > > further > > > information in increasing this limit > > > > > > Best Regards > > > Niels > > > > > > On Mon, Jul 9, 2012 at 8:01 PM, João Ramos <[email protected]> > wrote: > > > > > > > I have a script that creates several hundred of views. > > > > At about 700, I start getting several errors and I've attached the > log > > > > output of them. > > > > > > > > Thanks in advance. > > > > > > > > > > > > > > > > -- > > > BinaryConstructors ApS > > > Vestergade 10a, 4th > > > 1456 Kbh K > > > Denmark > > > phone: +4529722259 > > > web: http://www.binaryconstructors.dk > > > mail: [email protected] > > > skype: nielsboldt > > > > > >
