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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
