Hello,

Thank you for your answer.
As I read, if the database is a memory db, then, once the server running 
the db would be shut down, all the changes to the content of the db would 
be lost and this is unacceptable for me. Did I understand this wrongly?

Regarding your comment with the requests being synchronized somewhere. The 
local servers I was talking about in the description are different / 
distinct / independent physical servers spread around the country. So we 
have different computers, each with its own separate independent process 
that reads data from the same central database. So the requests, in the way 
that I understood your comment, cannot be synchronized. 

Sorry, I am not sure what do you mean by "check that you are not using file 
mode". In my understanding, h2 can be run in embedded, server and mixed 
mode. What does file mode mean?

The first experiments with MULTI_THREAD did not gave very different 
results, but I did not reach a final conclusion yet (the intermediate 
conclusion is that it makes no difference using MULTI_THREAD).

I am wondering if anybody has experience with running H2 in such a 
configuration? Intuitively, I would expect that when 50 servers are reading 
the same database it will be slower than when 1 server is reading the 
database. But how slow can it get? I am wondering if I am reaching a kind 
of limit in how scalable H2 is?

On Saturday, September 27, 2014 10:11:55 AM UTC+2, rado wrote:
>
> Hello,
> What you are describing sounds to me like the requests are being 
> synchronized somewhere. You are talking about local servers- check that you 
> are not using file mode. I think that MULTI_THREAD should help. Also, if 
> there  is no writting to database you can try to ease the transaction 
> isolation and disable the transactions log. If the server has enogh memory 
> then try to load the database as memory database.
>
> Cheers
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to