IBSurgeon offers optimization service for Firebird databases, which includes the following:
This basic package is enough to identify and fix performance problem for 90% cases.
- Hardware and OS settings investigation
- Firebird performance measurement, including transaction performance investigation
- Tuning recommendations for hardware, OS and Firebird settings.
- Firebird database indices configuration investigation
- Maintenance recommendations (including sweep/garbage collection, backup and transaction management).
- Indices and SQLs recommendations
- Licenses for our performance tools (IBSurgeon Transaction Monitor, FBDataGuard, FBScanner, IBAnalyst) which are valid during investigation period
This package costs USD$1200 (EUR 900), for the long and complex cases price will be higher (exact quote is discussed after initial investigation).
For the complex cases we offer deep Firebird tuning, which can include development of custom features for Firebird engine, price is negotiated separately.
Our optimization expert, Dmitri Kuzmenko, is well-known among Firebird and InterBase users. He wrote and introduced at 2005 Firebird Conference paper - "Firebird Performance Optimization for Different Applications" where some our results and optimization techniques are described.
Also as a chief developer of IBAnalyst (tool to analyze database statistics and find database problems with indices and garbage), Dmitry has a lot of experience in identifying and solving optimization puzzles. Dmitry supervises all optimization services and pay maximum attention to each case.
We also have core Firebird developers as consultants for difficult optimization cases.
We've performed a series of TPC based tests (TPC-R and TPC-C) which showed interesting results and highlighted some practical tips and tricks related with configuration parameters and hardware settings. One of the test was creating and testing performance of 1 Terabyte Firebird database.
Our real-world customers run databases up to 500Gb which we helped to tune.
Contact us now: send enquiry to email@example.com and we will contact you shortly.