couchdb-user mailing list archives

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

I have finalized compacting the view and the size sits now at 781.9MB! Sheesh! Now we're taking!
I hope it helps someone having the same issue!

</relieved>

-- Tito

On Feb 13, 2014, at 6:09 PM, Tito Ciuro <tciuro@mac.com> wrote:

> 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