IBProvider Developer's Blog

Load test of IBP with FB4

Hello Everyone.

I have just gotten the some of results about load test IBP with FB4 those can be analyzed and compared.

In short, the situation is the same as for FB3.

Test with using built-in Firebird client

[20.05.2023 23:36:21] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[20.05.2023 23:36:21] [info] Provider Version:5.29.0.42372
[20.05.2023 23:36:21] [info] Server Name     :Firebird
[20.05.2023 23:36:21] [info] Server Version  :4.0.3.2937
[20.05.2023 23:36:21] [info] Client Name     :LCPI.IBProvider.RemoteFB
[20.05.2023 23:36:21] [info] Client Version  :5.29.0.42372
[20.05.2023 23:36:21] [info] Database ODS    :13.0
[20.05.2023 23:36:21] [info] Database Dialect:3
...
[22.05.2023 01:26:07] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[22.05.2023 01:26:07] [summary] [TESTS]
[22.05.2023 01:26:07] [summary] EXECUTED      : 738000
[22.05.2023 01:26:07] [summary] SUCCEEDED     : 737931
[22.05.2023 01:26:07] [summary] FAILED        : 12 [ 12 error(s) ]
[22.05.2023 01:26:07] [summary] WITH WARNINGS : 57 [ 89 warning(s) ]
[22.05.2023 01:26:07] [summary] 
[22.05.2023 01:26:07] [summary] - - - - - - - - - - - - - - - - - - - - - -
[22.05.2023 01:26:07] [summary] [TEST TIMES]
[22.05.2023 01:26:07] [summary] REAL          : 9261941591927 [10 day(s)17:16:34.1591927]
[22.05.2023 01:26:07] [summary] USER          : 888992968750  [1 day(s)00:41:39.2968750]
[22.05.2023 01:26:07] [summary] KERNEL        : 369377500000  [10:15:37.7500000]
[22.05.2023 01:26:07] [summary] TOTAL         : 1258370468750 [1 day(s)10:57:17.0468750]
[22.05.2023 01:26:07] 
[22.05.2023 01:26:07] [TEST HEAP] Test heap is empty
[22.05.2023 01:26:07] [TEST HEAP] Validate ... OK
[22.05.2023 01:26:07] [TEST HEAP] Destroy ... OK
[22.05.2023 01:26:07] 
[22.05.2023 01:26:07] [summary] ------------------------------------------- [PROCESS INFORMATION]
[22.05.2023 01:26:07] [summary] [VIRTUAL MEMORY]
[22.05.2023 01:26:07] [summary] 
[22.05.2023 01:26:07] [summary] PRIVATE BYTES      : 28392 KB       [27MB 744KB]
[22.05.2023 01:26:07] [summary] PEAK PRIVATE BYTES : 13077864 KB    [12GB 483MB 360KB]
[22.05.2023 01:26:07] [summary] VIRTUAL SIZE       : 4539936 KB     [4GB 337MB 544KB]
[22.05.2023 01:26:07] [summary] PAGE FAULT COUNT   : 117698046
[22.05.2023 01:26:07] [summary] 
[22.05.2023 01:26:07] [summary] - - - - - - - - - - - - - - - - - - - - - -
[22.05.2023 01:26:07] [summary] [HANDLES]
[22.05.2023 01:26:07] [summary] 
[22.05.2023 01:26:07] [summary] HANDLES            : 176
[22.05.2023 01:26:07] [summary] 
[22.05.2023 01:26:07] [summary] - - - - - - - - - - - - - - - - - - - - - -
[22.05.2023 01:26:07] [summary] TOTAL ERRORS  : 12
[22.05.2023 01:26:07] [summary] TOTAL WARNINGS: 89
[22.05.2023 01:26:07] [summary] FULL PASSES   : 1
[22.05.2023 01:26:07] [summary] GEN TESTS     : 8332072

Test with using fbclient.dll

[23.05.2023 05:14:21] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[23.05.2023 05:14:21] [info] Provider Version:5.29.0.42372
[23.05.2023 05:14:21] [info] Server Name     :Firebird
[23.05.2023 05:14:21] [info] Server Version  :4.0.3.2937
[23.05.2023 05:14:21] [info] Client Name     :Firebird
[23.05.2023 05:14:21] [info] Client Version  :4.0.3.2937
[23.05.2023 05:14:21] [info] Database ODS    :13.0
[23.05.2023 05:14:21] [info] Database Dialect:3
...
[24.05.2023 07:11:58] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[24.05.2023 07:11:58] [summary] [TESTS]
[24.05.2023 07:11:58] [summary] EXECUTED      : 738012
[24.05.2023 07:11:58] [summary] SUCCEEDED     : 737946
[24.05.2023 07:11:58] [summary] FAILED        : 17 [ 17 error(s) ]
[24.05.2023 07:11:58] [summary] WITH WARNINGS : 50 [ 106 warning(s) ]
[24.05.2023 07:11:58] [summary] 
[24.05.2023 07:11:58] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.05.2023 07:11:58] [summary] [TEST TIMES]
[24.05.2023 07:11:58] [summary] REAL          : 9308170696534 [10 day(s)18:33:37.0696534]
[24.05.2023 07:11:58] [summary] USER          : 1063273750000 [1 day(s)05:32:07.3750000]
[24.05.2023 07:11:58] [summary] KERNEL        : 389622968750  [10:49:22.2968750]
[24.05.2023 07:11:58] [summary] TOTAL         : 1452896718750 [1 day(s)16:21:29.6718750]
[24.05.2023 07:11:58] 
[24.05.2023 07:11:58] [TEST HEAP] Test heap is empty
[24.05.2023 07:11:58] [TEST HEAP] Validate ... OK
[24.05.2023 07:11:58] [TEST HEAP] Destroy ... OK
[24.05.2023 07:11:58] 
[24.05.2023 07:11:58] [summary] ------------------------------------------- [PROCESS INFORMATION]
[24.05.2023 07:11:58] [summary] [VIRTUAL MEMORY]
[24.05.2023 07:11:58] [summary] 
[24.05.2023 07:11:58] [summary] PRIVATE BYTES      : 476108 KB      [464MB 972KB]
[24.05.2023 07:11:58] [summary] PEAK PRIVATE BYTES : 13164124 KB    [12GB 567MB 604KB]
[24.05.2023 07:11:58] [summary] VIRTUAL SIZE       : 5006404 KB     [4GB 793MB 68KB]
[24.05.2023 07:11:58] [summary] PAGE FAULT COUNT   : 503582383
[24.05.2023 07:11:58] [summary] 
[24.05.2023 07:11:58] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.05.2023 07:11:58] [summary] [HANDLES]
[24.05.2023 07:11:58] [summary] 
[24.05.2023 07:11:58] [summary] HANDLES            : 255
[24.05.2023 07:11:58] [summary] 
[24.05.2023 07:11:58] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.05.2023 07:11:58] [summary] TOTAL ERRORS  : 17
[24.05.2023 07:11:58] [summary] TOTAL WARNINGS: 106
[24.05.2023 07:11:58] [summary] FULL PASSES   : 1
[24.05.2023 07:11:58] [summary] GEN TESTS     : 8332072

The errors in first case (built-in client) are linked with new unsupported FB4 datatypes. Will be fixed in next IBP releases.

These errors exist in second case plus the old problems of fbclient.dll with statement cancel.

—
In general, the current state is not so bad.

The support of INT128 [FB4]

Hello All,

The new build of IBProvider Trial [42372] provides the completed support of INT128 and NUMERIC that is based on INT128.

You can use these types for simple values and, of course, for values with arrays.

There were created and passed lots of different tests, so I hope am sure that all is OK.

By default provider maps these types on DBTYPE_NUMERIC. If you work with IBProvider through ADODB you will get this data as BSTR values.

UPD. Let me know, if you are a registered customer with active licenses and you want to get this release without trial limitations.

The initial support of FB4

Hello Everyone.

The new IBProvider Trial [build 42030] includes the initial support for Firebird v4.

The primary limitation: this version is not able to read and write values with new datatypes (INT128, DECFLOATxx, TIME/TIMESTAMP WITH TIME ZONE) but you can read the metadata of these things.

You can connect to FB4 through fbclient.dll and directly (dbclient_type=fb.direct). Second method is preferred.

The direct connection to FB4 uses thirteenth protocol and supports all the things of FB3.

This version contains many others changes and as mininum a couple of bug fixes, too.

All the standard tests were passed and of course they continue working right now.

Let us know if you have any problems or questions.

Thanks.

Trial IBProvider v5.28.0.40888

Hello All.

New trial build contains an improvement for the built-in Firebird client. It allows to use the protocol v12 for work with FB3. There were problems with BOOLEAN datatype and BLOB.

You can define the used network protocol through the initialization property «remote:protocol».

I hope, the new version of IBProvider will be released within this month. It needs to finish important things those will be required in the future.

The field news

IBProvider has lots of properties help solve different problems. From time to time they are used in the real world:

Field news :)

Ok.

Yesterday I downloaded all the FB4-0-2 files from firebirdsql.org.

Today I opened the folder with these files and stared at them.

It has been waiting for me for long time 🙂

PS. Explanation — it is the release notes of a previous release.

20 years of ibprovider.com

Let’s smile and go on.

DLL Hell v2

Hello everyone.

A few years ago we split IBProvider module for sharing a thread manager with our OLE DB connection pool.

Now we did the next step. (далее…)

The picture of day

I’m really hating a standard COM infrastructure for it inhumanity error messages.

Therefore my COM will be with blackJack and extended error messages.

IBProvider Trial v5.26.0.37386

Hello Everyone.

I would like to say that new IBProvider v5.26 has gone even closer to release.

Current trial is based on a new component infrastructure which resolves a couple of problems.

The first problem was connected with the single-threaded creation and destruction of COM objects. This was a pay for threads within DLL. Now this problem is solved.

The second problem was connected with internal COM objects. They behaved like public COM objects with all the linked costs. Now these objects are detached from public infrastructure and it improves the overall performance of COM server.

Of course, all these improvements won’t provide any visible effects for simple applications. But they are really useful for heavy multithreaded systems like our primary system for load testing. And this system shows that the new provider began to work better.

In any rate, without such changes it is hard to move ahead 🙂

—
I don’t want to add new seriously changes in these assemblies and really hope that this version will be released as is 🙂

Load tests have already run.