On Jul 3, 2011, at 8:11 PM, Matthew John <[email protected]> wrote:
> 1) I am familiar with MySql systems. In one of the applications I ve made, > whenever the server gets restarted I used to perform a warm up (similar to > Select * from *) inorder to populate the cache. And this used to take almost > like half an hour. How does it happen in CuuchDB and how long might it take > for the "warm up" That sounds like it would depend totally on the size of the database, and the server's disk speed and amount of RAM. (It seems like a strange thing to do anyway; shoving every row through the cache is going to leave it in a fairly random state that won't reflect how much different rows actually get used.) > 2) I understand that all the MR queries (views) to be used in the system has > to be coded in the Design document. Does that mean a super-set of all > possible queries which we might use in the System has to be coded in the > Design doc? Can this be added on the fly (dynamic) Sure; design docs are just documents [rows] and can be updated at any time. But in practice, most SQL based apps also have a fixed set of hardcoded queries that they plug parameters into at runtime, so this isn't very different. --Jens
