I think you'd just need to do a test and see. It probably depends on the size and complexity of your databases and what kind of queries you are running against them.

Ryan


On 19/01/2013 2:23 AM, Paul Barriscale wrote:
Hi,

I'm investigating H2 as a database for moving a desktop application to the web. It's a specialized planning tool used for planning data storage usage. We use a database to represent a snapshot of the plan at a single point in time. For a single user on the desktop version this meant they could have many databases, maybe 50+ in a single instance, currently SQL Server 2005 Express. Right now there could be a few hundred users of the application, all running the desktop application on their machines.

The Features section of the site mentions that the number of open database is only limited by the memory available. Does anybody have experience of using H2 with large numbers of databases. We could be talking a few thousand databases! Obviously not every user is going to be using all the databases at the same time, so we could potentially load and open databases as needed. Is that possible?

Any help would be great.

Thanks,
Paul
--
You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/a8-5nM1kkHwJ.
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.

--
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.

Reply via email to