Re: Update on the status of Mckoi SQL

[Tobias Downer <toby@xxxxxxxxx>]

This will not be an issue in the next release.  The new data store 
system can manage many tables without having to create a new file handle 
for each table.

Toby.


M. A. Sridhar wrote:
> Hi Toby,
> 
> I'm very happy to hear that the development is making progress.
> 
> There is one aspect that I would like to mention. The current Mckoi 
> implementation seems to keep lots of files open, and in large 
> deployments, it causes the JVM to fail with a "too many open files" 
> error. My database uses about 250 tables, and I create a separate 
> database instance for each customer in hosted mode. This seems to imply 
> (I'm guessing here) that Mckoi opens n*250 files when there are n 
> instances, and that causes problems with the JVM. This is unfortunately 
> a show-stopper for me.
> 
> I am hoping that you will have addressed this problem with the new version.
> 
> Mckoi has proven to be an extremely reliable, easy-to-use piece of 
> software. Thanks for the great work.
> 
> Best regards.
>  
> M. A. Sridhar
> |m_a_sridhar at yahoo dot com|