OK thanks for the info. Will start putting together a prototype and see what the results are.
Thanks, Paul On Monday, 21 January 2013 05:33:04 UTC, Noel Grandin wrote: > > 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]. >> 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/Fc1RsjcLWaYJ. 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.
