Hey folks, I liked to use h2 database for a multi user envoirment. For security reasons, every user in my system should have his own database encrypted with his user password. So, every user needs his own connection for a transaction.
Everything works without any problem until I've concurrent user working on my system. Each database transaction (including connection, query, closeing) is processed with under 160 ms. If i handle 40 concurrent transaction, the database slows down (up to 2600ms per request). Every single user request is handled by a servlet, which does the complete transaction. It looks for me like a synchronization problem. But every request connects to it's own database. There shouldn't be a syncronization problem. It doesn't make any difference if I am using a file connection or tcp connection. It's always slow! I would appreciate any tiny hint! Thanks. Greetings Felix --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
