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.