Publish date: 2020-12-25
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
Publish date: 2020-12-25. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.