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.
For fans only:
For the first time, we managed to perform all IBProvider system tests applicable to Firebird v3 in one run. This took 26 days and a ten-core processor.
Full note text: https://www.ibprovider.com/eng/news/n_181010.html
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).