rpiaggio opened a new issue #932: Enable temporary views in CouchDB 2.x URL: https://github.com/apache/couchdb/issues/932 ## Expected Behavior The same behavior as in version 1.x, albeit with the potential speedup provided by sharding. ## Current Behavior Temporary index queries fail (not implemented in version 2). ## Your Environment We use CouchDB to store data in a survey-like system, where we store hundreds of variables for each document. For statistical analysis purposes, we allow ad-hoc queries, where any of these variables and be counted or used for filters. We understand that temporary indexes force a reindex of the entire DB when they are invoked. In our case, this is mitigated by: * Very few users are allow to perform these analyses, and they don't do it often. * These users are warned about the impact of the queries. * It can be performed on a replica instead of the main database (replication is one of the points where CouchDB shines after all). We understand that temporary indexes were disabled because can be abused and degrade performance significantly, but we cannot create regular indices for the millions of combinations of variables that we use. At the moment, the only viable alternate solution that we can think of is creating a regular index for every query and then deleting it after a while. (We would like to keep the functionality of 1.x where subsequent queries return results immediately after the first query, we suspect that some form of caching is probably going on.) Because of the perils of temporary views, maybe they can be disabled by default but an option can be providedn to enable them. We are currently unable to upgrade to version 2.x because of this limitation.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
