Activity

Adrian Lungu's activity

From 06/30/2020 to 07/29/2020

09:21 AM Database Support #4701: try to improve H2 transaction commit performance: I uploaded @fwd-h2-1.4.200-20200727.jar@ to @devsrv01:/tmp/@, which includes the patch mentioned in #4701-38. Adrian Lungu
09:14 AM Database Support #4701: try to improve H2 transaction commit performance: I found out that the transactional keyword was exploiting a vulnerability of constraints inside create table statemen... Adrian Lungu

07:44 AM Database Support #4701: try to improve H2 transaction commit performance: Moved the @Timeout trying to lock table "SYS"@ topic from #4753 here.
# The exception can appear with different st... Adrian Lungu

08:01 AM Database Support #4701: try to improve H2 transaction commit performance: After Java profiling the #4701-17 testcase, I got the following results for 1.4.200 patched:
!profiling_mv_vs_page... Adrian Lungu
06:50 AM Database Support #4701: try to improve H2 transaction commit performance: Below there is a comparison between 1.4.197 patched using PageStore, 1.4.200 patched using PageStore and 1.4.200 usin... Adrian Lungu

11:21 AM Database Support #4701: try to improve H2 transaction commit performance: > Adrian, I should have confirmed this at the beginning, but was your performance comparison work done with the MVSto... Adrian Lungu

09:09 AM Database Support #4701: try to improve H2 transaction commit performance: I attached the @src/main/org/h2/engine/Session.java@ file.
> # A lot of users are accessing the database. @org.h2... Adrian Lungu

09:49 AM Database Support #4701: try to improve H2 transaction commit performance: The @org.h2.Session.cleanTempTables@ direction was a good starting point. H2 was sequentially checking all local temp... Adrian Lungu

02:03 PM Database Support #4702: write temp-table performance test cases: Stanislav, I will try to reproduce the exception and see if it related to @fwd-h2-1.4.200-20200709.jar@.
I remember... Adrian Lungu

11:19 AM Database Support #4701: try to improve H2 transaction commit performance: I created a test with 1000 temp-tables and the suggested loop. The transaction is in fact committed after each iterat... Adrian Lungu

11:49 AM Database Support #4701: try to improve H2 transaction commit performance: I investigated the H2 sources and eventually tried out some optimizations, but without any considerable performance b... Adrian Lungu

04:34 PM Database Support #4701: try to improve H2 transaction commit performance: I attached the patch based on @h2_synchronization_transactional_fix_20200703a.patch@, but compatible with the 1.4.200... Adrian Lungu
02:44 PM Database Support #4701: try to improve H2 transaction commit performance: Stanislav,
I attached the h2 versions I used in testing. I can't attach the already built ones as they are too bi... Adrian Lungu
07:33 AM Database Support #4701 (WIP): try to improve H2 transaction commit performance: Adrian Lungu
07:33 AM Database Support #4701: try to improve H2 transaction commit performance: I have computed the testing results for 1.4.200 and 1.4.200 patched. The spreadsheet is attached and a representative... Adrian Lungu

04:05 PM Database Support #4701: try to improve H2 transaction commit performance: I shared the findings in #4057. I will go ahead with testing the 1.4.200 version. Need just some syntax changes to th... Adrian Lungu
11:26 AM Database Support #4701: try to improve H2 transaction commit performance: I have done some testing using the Apache JMeter in order to see some differences between H2 versions: 1.4.196, 1.4.1... Adrian Lungu
04:01 PM Database Bug #4057: h2 performance degradation: I've done a testing effort in comparing 1.4.196, 1.4.197, 1.4.197 patched, 1.4.198 and 1.4.199. I shared the results ... Adrian Lungu

Also available in: Atom