Hi I run attached test at AWS r3.8xlarge instance (32 core, 256 GB RAM). The test has 100 threads which perform inserts into one simple table
*Test #1 - TCP server* dbUrl = "jdbc:h2:tcp://localhost:9002/nioMemFS:db;DB_CLOSE_DELAY=-1;MULTI_THREADED=1" At the very beginning I get 25K inserts/sec, then performance slowly decreased and come to 10K inserts/sec after 1M inserts *Test #2 - embedded* dbUrl = "jdbc:h2:nioMemFS:db;MULTI_THREADED=1" I get stable troughput 70K inserts/sec __________________________________________ In both cases CPU was used less then 10% Questions: 1. It there anything I can do to increase troughput of TCP server? I need at least 50K insert/second 2. Why server performance goes down? And why it's only at TCP server -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
