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.

Firebird – 1 terabyte database tests and performance report

We have made 1 terabyte database test with Firebird 2.1. Read more. Questions?

In this experiment Firebird shows the following results

Undoubted ability to handle big databases. We are pretty sure that it’s possible to create and use 32 Tb database on appropriate hardware, and Firebird will show the same high performance as it shows for smaller databases (i.e., 1Tb and below).

Good scalability and amazingly small footprint. 1Tb database was created at usual desktop computer and, more important, it can be used to perform general queries: if you don’t fetch millions of records, query’s speed is the same as it is for moderate size databases (10-15Gb).