I succeeded in handling H2 from c using libpq library as described by many posts, but found a strange limitation on the speed of execution of the single execute commands. It seems that I can't do more than 25 execute per second on the same connection, which seems quite strange giving that when using JDBC in Java or from C using JNI I can have 20K inserts/second.
I tried to do multiple connections using multithreading and I see that it constantly is throttled to 25/s for each tread-connection. (But if I can manage to have 10 concurrent threads each with their connection I have then 250 inserts/s). Is there anything that I can do to have a better throughput using a single thread/connection? Note: I'm testing on a Linux ubuntu 16.04, with i7 quad-core processor and 16G ram. Thanks for any advice, claudio. -- 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.
