Вести с полей

Привет всем.

Обновили и расширили варианты оплаты на русской части сайта ibprovider.com.

Можно выписать счет или оплатить онлайн через YooKassa.


Я чуть мозг не вывихнул, пока перестраивался на программирование под web 🙂

IBProvider v5.34

A new version of IBProvider was completely tested and released.

While this version was developing I found and fixed one really old problem of loading an array description from database. Provider used an incorrect query that might (only theoretical) return a wrong result and (that is important) had a wrong PLAN.

A correction of second thing reduced an execution time of all the load tests (FB4, d1/d3, 32/64 bits, direct/fbclient, debug/release) to one week instead two ones.

Here are old and new results of the one combination.

Old IBProvider v3.33 (x64)

[22.10.2023 22:48:40] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[22.10.2023 22:48:40] [info] Provider Version:5.33.0.45641
[22.10.2023 22:48:40] [info] Server Name     :Firebird
[22.10.2023 22:48:40] [info] Server Version  :4.0.4.3002
[22.10.2023 22:48:40] [info] Client Name     :LCPI.IBProvider.RemoteFB
[22.10.2023 22:48:40] [info] Client Version  :5.33.0.45641
[22.10.2023 22:48:40] [info] Database ODS    :13.0
[22.10.2023 22:48:40] [info] Database Dialect:3
...
[24.10.2023 02:37:48] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[24.10.2023 02:37:48] [summary] [TESTS]
[24.10.2023 02:37:48] [summary] EXECUTED      : 746770
[24.10.2023 02:37:48] [summary] SUCCEEDED     : 746712
[24.10.2023 02:37:48] [summary] FAILED        : 0
[24.10.2023 02:37:48] [summary] WITH WARNINGS : 58 [ 79 warning(s) ]
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.10.2023 02:37:48] [summary] [TEST TIMES]
[24.10.2023 02:37:48] [summary] REAL          : 9979236316708 [11 day(s)13:12:03.6316708]
[24.10.2023 02:37:48] [summary] USER          : 962695781250  [1 day(s)02:44:29.5781250]
[24.10.2023 02:37:48] [summary] KERNEL        : 395262187500  [10:58:46.2187500]
[24.10.2023 02:37:48] [summary] TOTAL         : 1357957968750 [1 day(s)13:43:15.7968750]
[24.10.2023 02:37:48] 
[24.10.2023 02:37:48] [TEST HEAP] Test heap is empty
[24.10.2023 02:37:48] [TEST HEAP] Validate ... OK
[24.10.2023 02:37:48] [TEST HEAP] Destroy ... OK
[24.10.2023 02:37:48] 
[24.10.2023 02:37:48] [summary] ------------------------------------------- [PROCESS INFORMATION]
[24.10.2023 02:37:48] [summary] [VIRTUAL MEMORY]
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] PRIVATE BYTES      : 25388 KB       [24MB 812KB]
[24.10.2023 02:37:48] [summary] PEAK PRIVATE BYTES : 13065068 KB    [12GB 470MB 876KB]
[24.10.2023 02:37:48] [summary] VIRTUAL SIZE       : 4492508 KB     [4GB 291MB 220KB]
[24.10.2023 02:37:48] [summary] PAGE FAULT COUNT   : 119397153
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.10.2023 02:37:48] [summary] [HANDLES]
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] HANDLES            : 173
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.10.2023 02:37:48] [summary] TOTAL ERRORS  : 0
[24.10.2023 02:37:48] [summary] TOTAL WARNINGS: 79
[24.10.2023 02:37:48] [summary] FULL PASSES   : 1
[24.10.2023 02:37:48] [summary] GEN TESTS     : 8340892

New IBProvider v3.34 64bit

[08.12.2023 02:44:54] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[08.12.2023 02:44:54] [info] Provider Version:5.34.0.46640
[08.12.2023 02:44:54] [info] Server Name     :Firebird
[08.12.2023 02:44:54] [info] Server Version  :4.0.5.3033
[08.12.2023 02:44:54] [info] Client Name     :LCPI.IBProvider.RemoteFB
[08.12.2023 02:44:54] [info] Client Version  :5.34.0.46640
[08.12.2023 02:44:54] [info] Database ODS    :13.0
[08.12.2023 02:44:54] [info] Database Dialect:3
...
[08.12.2023 15:17:08] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[08.12.2023 15:17:08] [summary] [TESTS]
[08.12.2023 15:17:08] [summary] EXECUTED      : 751898
[08.12.2023 15:17:08] [summary] SUCCEEDED     : 751844
[08.12.2023 15:17:08] [summary] FAILED        : 0
[08.12.2023 15:17:08] [summary] WITH WARNINGS : 54 [ 73 warning(s) ]
[08.12.2023 15:17:08] [summary] 
[08.12.2023 15:17:08] [summary] - - - - - - - - - - - - - - - - - - - - - -
[08.12.2023 15:17:08] [summary] [TEST TIMES]
[08.12.2023 15:17:08] [summary] REAL          : 4273219237213 [4 day(s)22:42:01.9237213]
[08.12.2023 15:17:08] [summary] USER          : 1171577343750 [1 day(s)08:32:37.7343750]
[08.12.2023 15:17:08] [summary] KERNEL        : 444367031250  [12:20:36.7031250]
[08.12.2023 15:17:08] [summary] TOTAL         : 1615944375000 [1 day(s)20:53:14.4375000]
[08.12.2023 15:17:08] 
[08.12.2023 15:17:08] [TEST HEAP] Test heap is empty
[08.12.2023 15:17:08] [TEST HEAP] Validate ... OK
[08.12.2023 15:17:08] [TEST HEAP] Destroy ... OK
[08.12.2023 15:17:08] 
[08.12.2023 15:17:08] [summary] ------------------------------------------- [PROCESS INFORMATION]
[08.12.2023 15:17:08] [summary] [VIRTUAL MEMORY]
[08.12.2023 15:17:08] [summary] 
[08.12.2023 15:17:08] [summary] PRIVATE BYTES      : 29632 KB       [28MB 960KB]
[08.12.2023 15:17:08] [summary] PEAK PRIVATE BYTES : 13083728 KB    [12GB 489MB 80KB]
[08.12.2023 15:17:08] [summary] VIRTUAL SIZE       : 4557348 KB     [4GB 354MB 548KB]
[08.12.2023 15:17:08] [summary] PAGE FAULT COUNT   : 124257081
[08.12.2023 15:17:08] [summary] 
[08.12.2023 15:17:08] [summary] - - - - - - - - - - - - - - - - - - - - - -
[08.12.2023 15:17:08] [summary] [HANDLES]
[08.12.2023 15:17:08] [summary] 
[08.12.2023 15:17:08] [summary] HANDLES            : 174
[08.12.2023 15:17:08] [summary] 
[08.12.2023 15:17:08] [summary] - - - - - - - - - - - - - - - - - - - - - -
[08.12.2023 15:17:08] [summary] TOTAL ERRORS  : 0
[08.12.2023 15:17:08] [summary] TOTAL WARNINGS: 73
[08.12.2023 15:17:08] [summary] FULL PASSES   : 1
[08.12.2023 15:17:08] [summary] GEN TESTS     : 8341521

It looks, for me, really fine.

IBProvider v5.33

Hello All.

The newest release of IBProvider v5.33 has been already available in the customer area.

This release provides the following main things:

  • Built-in zlib library is v1.3
  • The problems with parsing PSQL code were fixed
  • The support of the latest DDL syntax (FB4, IB) was implemented

The part of load tests was already finished. For example:

[22.10.2023 22:48:40] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[22.10.2023 22:48:40] [info] Provider Version:5.33.0.45641
[22.10.2023 22:48:40] [info] Server Name     :Firebird
[22.10.2023 22:48:40] [info] Server Version  :4.0.4.3002
[22.10.2023 22:48:40] [info] Client Name     :LCPI.IBProvider.RemoteFB
[22.10.2023 22:48:40] [info] Client Version  :5.33.0.45641
[22.10.2023 22:48:40] [info] Database ODS    :13.0
[22.10.2023 22:48:40] [info] Database Dialect:3
[22.10.2023 22:48:40] [info] ConnectionString:

provider=LCPI.IBProvider.5.Private.vc17.release;location=inet4://localhost:3070/d:\database\ram\FB40_PORT3070\ibp_test_fb40_d3_2.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;icu_library=icuuc63.dll;icuin_library=icuin63.dll;dbclient_type=fb.direct;remote:wire_compression=required;

[22.10.2023 22:48:40] [ExecuteTests] 
[22.10.2023 22:48:40] [ExecuteTests] Enter [cancel] for interrupt execution
[22.10.2023 22:48:40] [ExecuteTests] 
[22.10.2023 22:48:40] Creation 10 thread(s)...
...
[24.10.2023 02:37:48] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[24.10.2023 02:37:48] [summary] [TESTS]
[24.10.2023 02:37:48] [summary] EXECUTED      : 746770
[24.10.2023 02:37:48] [summary] SUCCEEDED     : 746712
[24.10.2023 02:37:48] [summary] FAILED        : 0
[24.10.2023 02:37:48] [summary] WITH WARNINGS : 58 [ 79 warning(s) ]
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.10.2023 02:37:48] [summary] [TEST TIMES]
[24.10.2023 02:37:48] [summary] REAL          : 9979236316708 [11 day(s)13:12:03.6316708]
[24.10.2023 02:37:48] [summary] USER          : 962695781250  [1 day(s)02:44:29.5781250]
[24.10.2023 02:37:48] [summary] KERNEL        : 395262187500  [10:58:46.2187500]
[24.10.2023 02:37:48] [summary] TOTAL         : 1357957968750 [1 day(s)13:43:15.7968750]
[24.10.2023 02:37:48] 
[24.10.2023 02:37:48] [TEST HEAP] Test heap is empty
[24.10.2023 02:37:48] [TEST HEAP] Validate ... OK
[24.10.2023 02:37:48] [TEST HEAP] Destroy ... OK
[24.10.2023 02:37:48] 
[24.10.2023 02:37:48] [summary] ------------------------------------------- [PROCESS INFORMATION]
[24.10.2023 02:37:48] [summary] [VIRTUAL MEMORY]
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] PRIVATE BYTES      : 25388 KB       [24MB 812KB]
[24.10.2023 02:37:48] [summary] PEAK PRIVATE BYTES : 13065068 KB    [12GB 470MB 876KB]
[24.10.2023 02:37:48] [summary] VIRTUAL SIZE       : 4492508 KB     [4GB 291MB 220KB]
[24.10.2023 02:37:48] [summary] PAGE FAULT COUNT   : 119397153
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.10.2023 02:37:48] [summary] [HANDLES]
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] HANDLES            : 173
[24.10.2023 02:37:48] [summary] 
[24.10.2023 02:37:48] [summary] - - - - - - - - - - - - - - - - - - - - - -
[24.10.2023 02:37:48] [summary] TOTAL ERRORS  : 0
[24.10.2023 02:37:48] [summary] TOTAL WARNINGS: 79
[24.10.2023 02:37:48] [summary] FULL PASSES   : 1
[24.10.2023 02:37:48] [summary] GEN TESTS     : 8340892

For about 2.5 thousand new tests were added.

The news about v5.33 at out main website will be published this week.

Field news

Hello Everyone.

The release x64 binary of the next IBProvider v5.32 was tested. All is OK 🙂

[17.09.2023 20:04:44] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[17.09.2023 20:04:44] [info] Provider Version:5.32.0.44369
[17.09.2023 20:04:44] [info] Server Name     :Firebird
[17.09.2023 20:04:44] [info] Server Version  :4.0.4.2984
[17.09.2023 20:04:44] [info] Client Name     :LCPI.IBProvider.RemoteFB
[17.09.2023 20:04:44] [info] Client Version  :5.32.0.44369
[17.09.2023 20:04:44] [info] Database ODS    :13.0
[17.09.2023 20:04:44] [info] Database Dialect:3
[17.09.2023 20:04:44] [info] ConnectionString:

provider=LCPI.IBProvider.5.Private.vc17.release;location=inet4://localhost:3070/d:\database\ram\FB40_PORT3070\ibp_test_fb40_d3_2.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;icu_library=icuuc63.dll;icuin_library=icuin63.dll;dbclient_type=fb.direct;

[17.09.2023 20:04:44] [ExecuteTests] 
[17.09.2023 20:04:44] [ExecuteTests] Enter [cancel] for interrupt execution
[17.09.2023 20:04:44] [ExecuteTests] 
[17.09.2023 20:04:44] Creation 10 thread(s)...
[17.09.2023 20:04:44] Start Thread01
[17.09.2023 20:04:44] Start Thread02
[17.09.2023 20:04:44] Start Thread03
[17.09.2023 20:04:44] Start Thread04
[17.09.2023 20:04:44] Start Thread05
[17.09.2023 20:04:44] Start Thread06
[17.09.2023 20:04:44] Start Thread07
[17.09.2023 20:04:44] Start Thread08
[17.09.2023 20:04:44] Start Thread09
[17.09.2023 20:04:44] Start Thread10
...
[18.09.2023 23:09:58] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[18.09.2023 23:09:58] [summary] [TESTS]
[18.09.2023 23:09:58] [summary] EXECUTED      : 744194
[18.09.2023 23:09:58] [summary] SUCCEEDED     : 744135
[18.09.2023 23:09:58] [summary] FAILED        : 0
[18.09.2023 23:09:58] [summary] WITH WARNINGS : 59 [ 93 warning(s) ]
[18.09.2023 23:09:58] [summary] 
[18.09.2023 23:09:58] [summary] - - - - - - - - - - - - - - - - - - - - - -
[18.09.2023 23:09:58] [summary] [TEST TIMES]
[18.09.2023 23:09:58] [summary] REAL          : 9717039743268 [11 day(s)05:55:03.9743268]
[18.09.2023 23:09:58] [summary] USER          : 981684062500  [1 day(s)03:16:08.4062500]
[18.09.2023 23:09:58] [summary] KERNEL        : 392442187500  [10:54:04.2187500]
[18.09.2023 23:09:58] [summary] TOTAL         : 1374126250000 [1 day(s)14:10:12.6250000]
[18.09.2023 23:09:58] 
[18.09.2023 23:09:58] [TEST HEAP] Test heap is empty
[18.09.2023 23:09:58] [TEST HEAP] Validate ... OK
[18.09.2023 23:09:58] [TEST HEAP] Destroy ... OK
[18.09.2023 23:09:58] 
[18.09.2023 23:09:58] [summary] ------------------------------------------- [PROCESS INFORMATION]
[18.09.2023 23:09:58] [summary] [VIRTUAL MEMORY]
[18.09.2023 23:09:58] [summary] 
[18.09.2023 23:09:58] [summary] PRIVATE BYTES      : 27232 KB       [26MB 608KB]
[18.09.2023 23:09:58] [summary] PEAK PRIVATE BYTES : 13046524 KB    [12GB 452MB 764KB]
[18.09.2023 23:09:58] [summary] VIRTUAL SIZE       : 4556388 KB     [4GB 353MB 612KB]
[18.09.2023 23:09:58] [summary] PAGE FAULT COUNT   : 116429845
[18.09.2023 23:09:58] [summary] 
[18.09.2023 23:09:58] [summary] - - - - - - - - - - - - - - - - - - - - - -
[18.09.2023 23:09:58] [summary] [HANDLES]
[18.09.2023 23:09:58] [summary] 
[18.09.2023 23:09:58] [summary] HANDLES            : 576
[18.09.2023 23:09:58] [summary] 
[18.09.2023 23:09:58] [summary] - - - - - - - - - - - - - - - - - - - - - -
[18.09.2023 23:09:58] [summary] TOTAL ERRORS  : 0
[18.09.2023 23:09:58] [summary] TOTAL WARNINGS: 93
[18.09.2023 23:09:58] [summary] FULL PASSES   : 1
[18.09.2023 23:09:58] [summary] GEN TESTS     : 8338268

Field news

Hello Everyone!

The first test iteration of the release candidate has been completed.

[12.09.2023 18:16:22] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_d.dll
[12.09.2023 18:16:22] [info] Provider Version:5.32.0.44369
[12.09.2023 18:16:22] [info] Server Name     :Firebird
[12.09.2023 18:16:22] [info] Server Version  :4.0.4.2984
[12.09.2023 18:16:22] [info] Client Name     :LCPI.IBProvider.RemoteFB
[12.09.2023 18:16:22] [info] Client Version  :5.32.0.44369
[12.09.2023 18:16:22] [info] Database ODS    :13.0
[12.09.2023 18:16:22] [info] Database Dialect:3
[12.09.2023 18:16:22] [info] ConnectionString:

provider=LCPI.IBProvider.5.Private.vc17.debug;location=inet4://localhost:3070/d:\database\ram\FB40_PORT3070\ibp_test_fb40_d3_2.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;icu_library=icuuc63.dll;icuin_library=icuin63.dll;dbclient_type=fb.direct;

[12.09.2023 18:16:22] [ExecuteTests] 
[12.09.2023 18:16:22] [ExecuteTests] Enter [cancel] for interrupt execution
[12.09.2023 18:16:22] [ExecuteTests] 
[12.09.2023 18:16:22] Creation 10 thread(s)...
...
[14.09.2023 03:21:04] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[14.09.2023 03:21:04] [summary] [TESTS]
[14.09.2023 03:21:04] [summary] EXECUTED      : 744194
[14.09.2023 03:21:04] [summary] SUCCEEDED     : 744126
[14.09.2023 03:21:04] [summary] FAILED        : 0
[14.09.2023 03:21:04] [summary] WITH WARNINGS : 68 [ 100 warning(s) ]
[14.09.2023 03:21:04] [summary] 
[14.09.2023 03:21:04] [summary] - - - - - - - - - - - - - - - - - - - - - -
[14.09.2023 03:21:04] [summary] [TEST TIMES]
[14.09.2023 03:21:04] [summary] REAL          : 11747546595004 [13 day(s)14:19:14.6595004]
[14.09.2023 03:21:04] [summary] USER          : 3326079531250 [3 day(s)20:23:27.9531250]
[14.09.2023 03:21:04] [summary] KERNEL        : 476050468750  [13:13:25.0468750]
[14.09.2023 03:21:04] [summary] TOTAL         : 3802130000000 [4 day(s)09:36:53]
[14.09.2023 03:21:04] 
[14.09.2023 03:21:04] [TEST HEAP] Test heap is empty
[14.09.2023 03:21:04] [TEST HEAP] Validate ... OK
[14.09.2023 03:21:05] [TEST HEAP] Destroy ... OK
[14.09.2023 03:21:05] 
[14.09.2023 03:21:05] [summary] ------------------------------------------- [PROCESS INFORMATION]
[14.09.2023 03:21:05] [summary] [VIRTUAL MEMORY]
[14.09.2023 03:21:05] [summary] 
[14.09.2023 03:21:05] [summary] PRIVATE BYTES      : 29104 KB       [28MB 432KB]
[14.09.2023 03:21:05] [summary] PEAK PRIVATE BYTES : 12951656 KB    [12GB 360MB 104KB]
[14.09.2023 03:21:05] [summary] VIRTUAL SIZE       : 4491608 KB     [4GB 290MB 344KB]
[14.09.2023 03:21:05] [summary] PAGE FAULT COUNT   : 118733841
[14.09.2023 03:21:05] [summary] 
[14.09.2023 03:21:05] [summary] - - - - - - - - - - - - - - - - - - - - - -
[14.09.2023 03:21:05] [summary] [HANDLES]
[14.09.2023 03:21:05] [summary] 
[14.09.2023 03:21:05] [summary] HANDLES            : 575
[14.09.2023 03:21:05] [summary] 
[14.09.2023 03:21:05] [summary] - - - - - - - - - - - - - - - - - - - - - -
[14.09.2023 03:21:05] [summary] TOTAL ERRORS  : 0
[14.09.2023 03:21:05] [summary] TOTAL WARNINGS: 100
[14.09.2023 03:21:05] [summary] FULL PASSES   : 1
[14.09.2023 03:21:05] [summary] GEN TESTS     : 8338268

It was the most scary part of this test process. The result of next parts can be predicted.

Field news

FB4. FINISH

FB4 and Visual Studio

I am verifying the new release of our ADO.NET provider for OLE DB and thinking that this picture will be useful for anyone, who is planning to start using the combination of FB4, .NET and IBProvider 🙂

Field news

The load tests of IBP v5.31.1 with FB4 has finished today. No real problems were detected.

A few little issues with first dialect have been already fixed in version 5.31.5.

During these tests Firebird ate the 116 days of my CPU time 🙂

It’s time to start testing IBP v5.31.5 and begin implementing the support of the last new FB4 datatype — «TIME WITH TIME ZONE».

I am not expected the problems here, although there can be unexpected surprises.

Alternative Text Literals

New IBProvider 5.31.1.43971 has added the support of UTF16 symbols for alternative text literals. It means that provider will be correctly processing the following query:

select _win1251 q’?мама, мама, что я буду делать??’ from rdb$database;

I hope that Firebird will be able to process this query in the near future.

Note that, you should use UTF8 connection charset for executing the such queries.

Release of ADO.NET Provider v1.27

Hello All.

It is a small update of our LCPI ADO.NET provider.

We have added the support of latest new IBProvider properties:

  • decfloat16_rules
  • decfloat34_rules
  • int128_rules
  • dbtimestamp_with_tz_rules
  • dbtime_with_tz_rules
  • timezones_source
  • icuin_library
  • icuin_library_64
  • sql_cache__scope
  • sql_cache__instance_id
  • sql_cache__size
  • sql_cache__time
  • sql_cache__max_len

All the changes were made in OleDbConnectionStringBuilder. You can see these changes in the connection configuration of DDEX provider.

Data provider was not changed.

Additionally, ADO.NET provider was tested with FB4. No problems were found, everything works as expected.