IBExpert Performance Workshop for databases and applications

Our workshop is aimed at software developers and development departments where Firebird is used as the database server.

The 2-day workshop can be carried out either at your premises, at our training center in Wardenburg or remotely using PC-Visit or TeamViewer and telephone.

We begin by analyzing the existing software. It is therefore important that you can access your development environment and a copy of the production database. This may, for example, be installed on a laptop or accessed remotely. This enables us to assess the impact of source code changes on the database connection.

As a development environment you can use Delphi, Lazarus, Visual Studio, Java or other tools.

To identify necessary enhancements we require remote access to a database server with an online running production database. This is necessary to identify any weaknesses or erratic behavior of the software with regard to index usage, SQL, transactions, and versioning. For effective evaluability Firebird version 2.5 or 3.0 should be in use.

If you have an older Firebird version in use, we can convert your database to make it compatible with Firebird 3.0 and develop an automated process for the conversion. For this you will need to book an additional workshop day.

The problematic SQLs are logged on the production database during runtime and optimized according to relevance. With the aid of a script, all SQL commands, which are relevant for the optimization, will from now on be logged immediately.

During the optimization process, you will learn about the criteria that the Firebird server uses to decide which indices to use and the reasons which lead to existing indexes not being used. We also analyze the construction of logged SQLs and propose improvements, which can be applied immediately in the source code in your own development environment. In certain cases, complex SQL commands can be replaced with or supplemented by stored procedures or updatable views.

Based on the results of the database statistics, we examine the operations in the applications's source code. Unnecessary commands are eliminated and, if necessary, we will identify their cause using simple logs, breakpoints and call stack analyzes.

To finish off, we identify further improvement proposals, along with performance indicators and benchmark results for you, based on the hardware and server configuration, in order to evaluate the hardware speed of your customer installations. A fast file server is not automatically a fast database server. We can deliver the arguments, so that your customers can find optimal systems for your software.

We have already carried out this workshop successfully for a number of customers worldwide. We were always able to optimize the software considerably. Immediate success stories were reported by end users on the first day.

You may direct any appointment requests or questions regarding this workshop to: sales@ibexpert.biz.
Payments only by prepayment upon receipt our order confirmation and invoice via email.