Performance Benchmarking Across Local Ostendo EnvironmentsWith Ostendo now operating across multiple platforms, we conducted performance benchmarking to evaluate database interaction speed under various conditions. The test was designed as follows:
- A standalone local environment was used to eliminate external latency variables associated with remote environments.
- Three identical copies of the same database were prepared:- Database 1: Update 242 on Firebird 2.5
- Database 2: Update 243 on Firebird 2.5
- Database 3: Update 243 on Firebird 5
Testing Methodology:
A purpose-built script was executed to Insert, Update, and Delete 500,000 records into a dynamically created table. For each database:
The script was run in a single-session context, and results were recorded.
The script was then run concurrently across four sessions, applying 2 million simultaneous transactions.
The test machine was rebooted between each environment test to ensure clean execution conditions.
Test Results:
Key Findings:
The results clearly demonstrate a substantial performance improvement when running Update 243 with Firebird 5, significantly outperforming both Update 242 and Update 243 under Firebird 2.5.
A fundamental reason for this performance gain between 242 and 243 is the change in our database connectivity approach. Prior versions relied on a dedicated Firebird-specific connection object. Our new architecture in Update 243 utilises a more flexible, generic connection component, which delivers both speed and technical adaptability.
Recommendation:
We encourage you to proactively communicate these performance improvements to your clients ahead of the 243 Public Release, ensuring they understand the tangible benefits of upgrading. |
|
