Load testing of IBProvider v5.21.1 and Firebird v3.0.7

We have good news for everyone who uses IBProvider in critical and complex systems.

A «large», multithreaded, load testing of the latest release of IBProvider v5.21.1 and Firebird v3.0.7 (SS, Win, x64) has been carried out.

This is more than 7 million tests that were performed on a 10-core processor.

The main point of this testing was that the global cache of the SQL query parser was used (sql_cache__scope=db).

As usual, the built-in client for Firebird (dbclient_type=fb.direct) was used.

Testing completed with no visible problems.

Process ID: 31684
 
[TEST HEAP] Initialize ... OK
 
[18.11.2020 13:21:59] [ExecuteTests] CommandLine:
 
target\ibp_oledb_test_vc16_x64_Release.exe  /thread_count 10 /log_file_prefix fb30-fb.direct-ram_w64_d3 /log_dir ..\_log\all\ /new_db_location "inet4://localhost/d:\database\ram\" /cn_str "provider=LCPI.IBProvider.5.Private.vc16.release;location=inet4://localhost/d:\database\ram\ibp_test_fb30_d3_all.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;dbclient_type=fb.direct;icu_library=icuuc52.dll;wchars_in_utf8_symbol=2;sql_cache__scope=db" /oledb_svc_cmp "LCPI.OleDbServices.DataInitManager.Local.1.Private.vc16.release" /test *
 
[18.11.2020 13:21:59] [ExecuteTests] Test Mask  : [*]
 
[18.11.2020 13:21:59] [info] Provider DLL    :lcpi.ibprovider-v5_vc16_w64_prof_i.dll
[18.11.2020 13:21:59] [info] Provider Version:5.21.1.36328
[18.11.2020 13:21:59] [info] Server Name     :Firebird
[18.11.2020 13:21:59] [info] Server Version  :3.0.7.33388
[18.11.2020 13:21:59] [info] Client Name     :LCPI.IBProvider.RemoteFB
[18.11.2020 13:21:59] [info] Client Version  :5.21.1.36328
[18.11.2020 13:21:59] [info] Database ODS    :12.0
[18.11.2020 13:21:59] [info] Database Dialect:3
[18.11.2020 13:21:59] [info] ConnectionString:
 
provider=LCPI.IBProvider.5.Private.vc16.release;location=inet4://localhost/d:\database\ram\ibp_test_fb30_d3_all.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;dbclient_type=fb.direct;icu_library=icuuc52.dll;wchars_in_utf8_symbol=2;sql_cache__scope=db
 
[18.11.2020 13:21:59] [ExecuteTests] 
[18.11.2020 13:21:59] [ExecuteTests] Enter [cancel] for interrupt execution
[18.11.2020 13:21:59] [ExecuteTests] 
[18.11.2020 13:21:59] Creation 10 thread(s)...
.......
[23.12.2020 17:55:44] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[23.12.2020 17:55:44] [summary] [TESTS]
[23.12.2020 17:55:44] [summary] EXECUTED      : 7055997
[23.12.2020 17:55:44] [summary] SUCCEEDED     : 7055933
[23.12.2020 17:55:44] [summary] FAILED        : 0
[23.12.2020 17:55:44] [summary] WITH WARNINGS : 64 [ 92 warning(s) ]
[23.12.2020 17:55:44] [summary] 
[23.12.2020 17:55:44] [summary] - - - - - - - - - - - - - - - - - - - - - -
[23.12.2020 17:55:44] [summary] [TEST TIMES]
[23.12.2020 17:55:44] [summary] REAL          : 303948587548855 [351 day(s)19:00:58.7548855]
[23.12.2020 17:55:44] [summary] USER          : 42100834062500 [48 day(s)17:28:03.4062500]
[23.12.2020 17:55:44] [summary] KERNEL        : 36739262187500 [42 day(s)12:32:06.2187500]
[23.12.2020 17:55:44] [summary] TOTAL         : 78840096250000 [91 day(s)06:00:09.6250000]
[23.12.2020 17:55:45] 
[23.12.2020 17:55:45] [TEST HEAP] Test heap is empty
[23.12.2020 17:55:45] [TEST HEAP] Validate ... OK
[23.12.2020 17:55:45] [TEST HEAP] Destroy ... OK
[23.12.2020 17:55:45] 
[23.12.2020 17:55:45] [summary] ------------------------------------------- [PROCESS INFORMATION]
[23.12.2020 17:55:45] [summary] [VIRTUAL MEMORY]
[23.12.2020 17:55:45] [summary] 
[23.12.2020 17:55:45] [summary] PRIVATE BYTES      : 22500 KB       [21MB 996KB]
[23.12.2020 17:55:45] [summary] PEAK PRIVATE BYTES : 13081912 KB    [12GB 487MB 312KB]
[23.12.2020 17:55:45] [summary] VIRTUAL SIZE       : 4620360 KB     [4GB 416MB 72KB]
[23.12.2020 17:55:45] [summary] PAGE FAULT COUNT   : 1612880775
[23.12.2020 17:55:45] [summary] 
[23.12.2020 17:55:45] [summary] - - - - - - - - - - - - - - - - - - - - - -
[23.12.2020 17:55:45] [summary] [HANDLES]
[23.12.2020 17:55:45] [summary] 
[23.12.2020 17:55:45] [summary] HANDLES            : 176
[23.12.2020 17:55:45] [summary] 
[23.12.2020 17:55:45] [summary] - - - - - - - - - - - - - - - - - - - - - -
[23.12.2020 17:55:45] [summary] TOTAL ERRORS  : 0
[23.12.2020 17:55:45] [summary] TOTAL WARNINGS: 92
[23.12.2020 17:55:45] [summary] FULL PASSES   : 1
[23.12.2020 17:55:45] [summary] GEN TESTS     : 8292754