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.
