Hi Folks, I have a community use case where I need to track: a) user id b) user action c) doc._id e) date.time
Wiki talks about short doc._id values making a huge difference on storage and performance. I am assuming that the same arguments also apply to view indexing as it uses the same b-tree indexing. Somewhere I have read that numeric values compare faster than strings, so I am thinking about using decimals for date.time in yymmdd.hhmmss format. Comments on this? For parts of the application, I need to keep track of all such logs in order to retain "user's slice" of what they have done. That is I would need to keep longer the ByUserId view, while ByDocId and/or ByDateTime views can be reduced for all of the logs that are older than x number of days. While it is somewhat of an open ended question, can you share some design suggestions? Thanks again, teslan
