Tag: Performance Comparer

Performance Comparer for Firebird (FBPC) version 1.1

Leave a comment

FBPC Performance Comparer for Firebird 1.1 is here with major improvements throughout the comparison workflow. The tool imports SQL commands recorded by the Firebird Trace API and runs them against two different environments, making it easier to evaluate server versions, configuration changes, and infrastructure.

This release focuses on safer testing, more trustworthy results, and much clearer problem diagnosis.]

The 8 main highlights

1. More reliable trace import

Trace files are now read correctly as UTF-8, reducing corrupted characters and improving the detection of commands, plans, and parameters. Generated trace.conf files now also include the exclusion filter correctly, using either current syntax or the legacy Firebird 2.5 syntax.

Read more

FBPC 1.0.3 is released

Leave a comment

A new version of Performance Comparer for Firebird (FBPC) is now available. Version 1.0.3 has the following changes:

  1. Fixed some parameters data type identifying logic (the traceapi writes the params data types based on their internal field type, not the declared type)
  2. The statement’s grid wasn’t showing a value when the statement execution time was below 1ms
  3. Added some error handling during the statements execution
  4. Now any errors during the execution of an statement will be logged in the errors.log file (in the application directory)

FBPC is a free tool that can help people to compare the performance of real life SQL statements between two Firebird versions, or even between the same Firebird version but with different configurations in firebird.conf.