Publish date: 2019-08-03

Load testing IBProvider v5.5.1 and Firebird v3.0.4

“Big” load testing of IBProvider v5 and Firebird v3 was carried out — more than 7 million tests were performed within 28 days.

Configuration

  • Intel 6950X (10C/20T), 128GB
  • Storage: RAM Disk (80GB)
  • Windows 10 Pro (x64, build 1809+)
  • IBProvider v5.5.1.31635 (x64, vc16)
  • LCPI OLE DB Services v1.9.0.646 (x64, vc16)
  • Firebird v3.0.4.33054 (Win, x64, SuperServer)

Primary results

Process ID: 41348
 
[TEST HEAP] Initialize ... OK

[04.07.2019 12:53:33] [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" /oledb_svc_cmp "LCPI.OleDbServices.DataInitManager.Local.1.Private.vc16.release" /test *
 
[04.07.2019 12:53:33] [ExecuteTests] Test Mask  : [*]
 
[04.07.2019 12:53:33] [info] Provider DLL    :lcpi.ibprovider_v5_vc16_w64_prof_i.dll
[04.07.2019 12:53:33] [info] Provider Version:5.5.1.31635
[04.07.2019 12:53:33] [info] Server Name     :Firebird
[04.07.2019 12:53:33] [info] Server Version  :3.0.4.33054
[04.07.2019 12:53:33] [info] Client Name     :LCPI.IBProvider.RemoteFB
[04.07.2019 12:53:33] [info] Client Version  :5.5.1.31635
[04.07.2019 12:53:33] [info] Database ODS    :12.0
[04.07.2019 12:53:33] [info] Database Dialect:3
[04.07.2019 12:53:33] [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
 
[04.07.2019 12:53:33] [ExecuteTests] 
[04.07.2019 12:53:33] [ExecuteTests] Enter [cancel] for interrupt execution
[04.07.2019 12:53:33] [ExecuteTests] 
[04.07.2019 12:53:33] Creation 10 thread(s)...
......
[01.08.2019 08:21:38] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[01.08.2019 08:21:38] [summary] [TESTS]
[01.08.2019 08:21:38] [summary] EXECUTED      : 7047654
[01.08.2019 08:21:38] [summary] SUCCEEDED     : 7047583
[01.08.2019 08:21:38] [summary] FAILED        : 0
[01.08.2019 08:21:38] [summary] WITH WARNINGS : 71 [ 91 warning(s) ]
[01.08.2019 08:21:38] [summary] 
[01.08.2019 08:21:38] [summary] - - - - - - - - - - - - - - - - - - - - - -
[01.08.2019 08:21:38] [summary] [TEST TIMES]
[01.08.2019 08:21:38] [summary] REAL          : 238993358664097 [276 day(s)14:42:15.8664097]
[01.08.2019 08:21:38] [summary] USER          : 34725919843750 [40 day(s)04:36:31.9843750]
[01.08.2019 08:21:38] [summary] KERNEL        : 28730854375000 [33 day(s)06:04:45.4375000]
[01.08.2019 08:21:38] [summary] TOTAL         : 63456774218750 [73 day(s)10:41:17.4218750]
[01.08.2019 08:21:39] 
[01.08.2019 08:21:39] [TEST HEAP] Test heap is empty
[01.08.2019 08:21:39] [TEST HEAP] Validate ... OK
[01.08.2019 08:21:39] [TEST HEAP] Destroy ... OK
[01.08.2019 08:21:39] 
[01.08.2019 08:21:39] [summary] ------------------------------------------- [PROCESS INFORMATION]
[01.08.2019 08:21:39] [summary] [VIRTUAL MEMORY]
[01.08.2019 08:21:39] [summary] 
[01.08.2019 08:21:39] [summary] PRIVATE BYTES      : 21828 KB       [21MB 324KB]
[01.08.2019 08:21:39] [summary] PEAK PRIVATE BYTES : 13036800 KB    [12GB 443MB 256KB]
[01.08.2019 08:21:39] [summary] VIRTUAL SIZE       : 4377296 KB     [4GB 178MB 720KB]
[01.08.2019 08:21:39] [summary] PAGE FAULT COUNT   : 1600894065
[01.08.2019 08:21:39] [summary] 
[01.08.2019 08:21:39] [summary] - - - - - - - - - - - - - - - - - - - - - -
[01.08.2019 08:21:39] [summary] [HANDLES]
[01.08.2019 08:21:39] [summary] 
[01.08.2019 08:21:39] [summary] HANDLES            : 173
[01.08.2019 08:21:39] [summary] 
[01.08.2019 08:21:39] [summary] - - - - - - - - - - - - - - - - - - - - - -
[01.08.2019 08:21:39] [summary] TOTAL ERRORS  : 0
[01.08.2019 08:21:39] [summary] TOTAL WARNINGS: 91
[01.08.2019 08:21:39] [summary] FULL PASSES   : 1
[01.08.2019 08:21:39] [summary] GEN TESTS     : 8293105

Publish date: 2019-08-03. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.