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.
