Memory and the maximum number of file descriptors per process will be your
limits. But a few thousand sounds very doable.

On Friday, 18 January 2013, 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]<javascript:_e({}, 'cvml', 
> '[email protected]');>
> .
> To unsubscribe from this group, send email to
> [email protected] <javascript:_e({}, 'cvml',
> 'h2-database%[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