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

Hello All.

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.

See additional info at our web site: https://www.ibprovider.com/eng/news/n_201225.html

Best regards, IBProvider Team.

IBProvider v5.21. SQL query parser cache implementation

In this release of IBProvider v5, we have implemented caching the results of our own SQL query parser.

The SQL query parser is needed to define the type of query and its parameter list as well as to divide the script into separate expressions.

The SQL query cache (SQL Cache) supplements the server query cache (Stmt Cache) implemented way back in the earlier versions of IBProvider v3.

Both SQL Cache and Stmt Cache use separate threads to service their own state.

The SQL query cache works for both user queries and service queries of updatable rowset.

Read more at IBProvider Site

Kind Regards, IBProvider Team.

IBProvider v5.19. Advanced load testing

Hello Everyone,

All changes in the current IBProvider release are related to the reorganization of the source code. If you are using v5.18, you can skip this update.

In addition to standard checks, IBProvider v5.19 (vc16, x64) went through advanced load testing. Within 42.5 days, ~7 million tests, applicable in FB3, were run through the debug build of the provider and our connection pool (LCPI OLE DB Services).

Full news text – https://www.ibprovider.com/eng/news/n_200723.html

Kind Regards, IBProvider team.

IBProvider News

Hello Everyone,

We are released new updates for our products.

IBProvider v5.16

LCPI ADO.NET Data Provider for OLE DB v1.18

Full news text: https://www.ibprovider.com/eng/news/n_200421.html

Kind Regards, IBProvider Team.

IBProvider v5.11. Support of WireCompression

Hello Everyone.

Starting from the current version (5.11), the built-in IBProvider client for Firebird (fb.direct) has support for connection data compression.

To enable compression, just specify «remote:wire_compression=enabled» in the connection string.

By default, IBProvider uses a built-in implementation of data compressor algorithms.

Full news text – https://www.ibprovider.com/eng/news/n_200123.html

Kind Regards, IBProvider Team.

1 2 3 9