couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tito Ciuro <tci...@mac.com>
Subject Why is the view index file size so huge?
Date Fri, 14 Feb 2014 02:09:50 GMT
Hello,

I have imported a total of 7 million documents into my sample database. The size is now 4.46GB.
For reference, I have created the view using the following function (formatted for clarity):

{
	"_id": "_design/test",
	"views": {
		"cityPath-byRating": {
			"map": "function(doc) {
				if (doc.type == 'test' && doc.rating && doc.testPath) {
					emit([doc.testPath + ' ' + doc.rating, doc._id], null);
				}
			}"
		}
	}
}

A sample key being shown in futon looks like this:

> ["Country.United States.San Francisco 100", "cf6ed60fb2e8b6d96122da7b0d1a26f2"]
> ID: cf6ed60fb2e8b6d96122da7b0d1a26f2


To my surprise, the final view file size (found in /Users/tito/Library/Application Support/CouchDB/var/lib/couchdb/.example_design/mrview)
is now 15.12GB! Four times the database size!? For one view alone? Is this expected or am
I doing something really silly? By the way, the UUID type configured is 'sequential'.

Any ideas?

Thanks,

-- Tito
Mime
View raw message