Hi, > Poor cache hit rate > Why is that? Wouldn't each database maintain its own cache?
Yes, but with some many databases each cache would need to be extremely small, otherwise it would run out of memory. Or, as an alternative, the cache sizes would need to be actively managed, which would complicate the code a lot. > "Too many open files" > According to > http://blogs.technet.com/b/markrussinovich/archive/2009/09/29/3283844.aspx > the limit is 16 million handles per process. I don't think you will run out > of file handles anytime soon. For Windows, I think there is no limit. But most other operating systems the limit is 256 or 1024 or so (ulimit -n). Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
