Hi, I am reading from a one embedded table (one milion of records). I am doing very intensive small reads (1-10 records) of all records.
When I am doing this in one connection I am done in 7 seconds. When I use the JdbcConnectionPool (with one thread - one connection) the very same thing is about 25 seconds. This is very strange. I understand that using connection pool is a bit slower than using one connection but three times? Since there is only one thread and one connection in the pool there should not be any blocking (waiting). Why am I getting these results? Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
