couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rogutės Sparnuotos <>
Subject Re: Performance of many documents vs large documents
Date Tue, 10 Jan 2012 23:50:36 GMT
Mark Hahn (2012-01-10 15:08):
> >  I could have one document per metric, leading to a small number of
> >  documents, but with each document containing ticks for every 5-second
> >  interval of any given day, these documents would quickly become huge.
> This would not only make the docs large, but you'd have a trail of huge
> outdated docs.  You would get n-squared storage problems quickly. Remember
> that all versions of a doc are stored until you do a compaction.

Usually metrics don't need to be updated. If this is the case, then there
should be no storage problems with huge docs (compared to tiny ones).

> I'd suggest one doc per second containing all the metric values for that
> second.

I would say do not dump more data than you need, i.e. don't use 1s
intervals if 5s is enough for you application.

Regarding doc size, my guess is that CouchDB's architecture does not care,
and the decision must be made based on intended usage, but the original
poster did not describe how he is going to use the data (what kind of
views, list and show functions will be needed).

--  Rogutės Sparnuotos

View raw message