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.

Reply via email to