Performance Testing @ the Frontline

A hidden world where small things make a big difference

Archive for the ‘Main’ Category

Steps to Upgrade Firebird v2.5.x to version 3.0.0 on Windows

Posted by Kim on Thursday, April 21, 2016


Just a few days ago Firebird v3.0.0 was released, and since many will update Firebird soon I wanted to make a small guide on how to do that on Windows. Read for more information about the release.

In this step-by-step guide I’ll outline what needs to be done to upgrade an existing Firebird v2.5.x server to version v3.0.0

After the steps the result should be a Stock (default) installation of Firebird v3.0.0 64bit.

What this guide does not have

I will not outline the process for upgrading the security database from old to new. This is an important step many installations, so be sure to check the Getting Started Guide from firebirdsql for more info!

What needs to be done for clients/client applications

Clients should ideally not have to change their code, only copy the new FBCLIENT.DLL file that resides in the Firebird Server installation folder to the clients.

By default the folders where the fbclient.dll files are (on the Server):

64bit installation:  C:\Program Files\Firebird\Firebird_3_0

32bit installation:  C:\Program Files (x86)\Firebird\Firebird_3_0

32bit and 64bit client DLL’s

You must remember to take the correct DLL for your application. If you install a 64bit Firebird the 32bit dll’s needed are stored under the WOW64\ folder in the installation folder.


Steps to Upgrade Firebird

Step 1 – Download what you will need

Download the installation files from

Choose the installer versions, as the installer will prepare your environment for your during installation.

Also make sure you read the Getting Started Guide for details & additional information.

Step 2 – Backup any old Databases

The file format (ODS version) changes, so be sure to backup your databases before you continue. Firebird 3 will not open old ODS format files.

Step 3- Shutdown/Uninstall old Firebird

In order to install the new Firebird v3 you need to shutdown and/or Uninstall the old one.

Shutdown and rename (leave installed if v3 installation fails for easy rollback):

Open services.msc and set Startup=Disabled for the Firebird Guardian (and the Firebird) process.

Go to C:\Program Files (x86)\Firebird and rename the “Firebird_2_5” folder to “Firebird_2_5-old”. This will make the new installer think there is no installation of Firebird on the server.


Run the uninstaller for Firebird v2.5

Step 4 – Install new Firebird Server

Run the installer you downloaded in step 1

After the installer has run, you should have a new Firebird server running on your machine as a Service.

Step 5 – Restore Databases

Using your preferred tools, restore the backed up databases.

Step 6 – Replace old fbclient.dll files

Copy the FBCLIENT.DLL file to all client machines, directories etc. The exact location depends on your client apps.

– Replace 32bit app fbclient.dll’s with new WOW64/fbclient.dll file
– Replace 64bit app fbclient.dll’s with new fbclient.dll file


And that’s about it! Test your applications and hopefully you can start enjoying the benefits of FBv3 immediately.

Posted in Firebird, Main | Leave a Comment »

Updated HTTP Client DLL for LoadRunner

Posted by Kim on Friday, March 22, 2013

Some time ago I posted an article about a custom DLL, and I’ve just updated the DLL and released the new version online.

The blog can be found at Custom DLL For LoadRunner,
and the download is on the Celarius downloads page.


Posted in Main | Leave a Comment »

Quick Install Guide for Apache+PHP+Firebird

Posted by Kim on Tuesday, November 13, 2012

Read the rest of this entry »

Posted in Firebird, Main | Tagged: , , | 3 Comments »

More about the online-ticket system …

Posted by Kim on Tuesday, September 27, 2011

It’s now been two weeks, and the on-line ticket sales system is still not working as it should. All the sales kiosks in the whole country are now closed until further notice and the system is still slow, and has serious defects.

During these two weeks there has been some more information released to the public, both from the vendor (Accenture), the customer (VR) and the hosting company Tieto.

Among the more interesting ones:

Posted in Main | Tagged: , | Leave a Comment »

A real story about an online-ticket system failing under load …

Posted by Kim on Thursday, September 15, 2011

When I read the news today, I just had to share this with the Blog – This is such a good example of when things don’t go as planned.

Today there’s been big news-flashes on several Finnish news sites about the local train monopoly firm and their new web-based ticket sales system crashing under a heavy load. They had introduced a new online ticket sales system, and where literally overrun. The official comment from the company was (translated) “we where surprised to see such traffic amounts”.

Two of the articles: here, and here

Read the rest of this entry »

Posted in Main | Tagged: | Leave a Comment »

The end of summer and the start of work

Posted by Kim on Friday, September 11, 2009

And so ends the summer & vacations and work begins … Back at the desk solving some the performance problems of the world.

Posted in Main | Leave a Comment »

Vacation time!

Posted by Kim on Saturday, August 8, 2009

A well performed Golf shot

A well performed Golf shot

Yes it’s true, I’m on vacation and not really doing very much at all … at least no real performance testing work!

But I’m active with planning the future for my company, and so we changed our look to more match the new comapny vision. In the near future I will start writing blog articles on the celarius pages as well as here, but they will be more from a commercial standpoint. This blog still remains as my private projects/discoveries etc blog..

And as it is summer and and I performed outstandingly on the golf-course on Friday I just have to include my opening shot on a 150 meter PAR 3 hole. The ball landed 15 cm (6″) from the flag, and my birdie was assured! The Birdie-whiskey we enjoyed afterwards was better than usual!

I hope you all have had a good summer and recharged your battires for a potentially demanding fall’09 !

Posted in Main | Leave a Comment »

Performance Test Tool Poll

Posted by Kim on Friday, May 8, 2009

I’ve had my poll for “Which LoadTesting tool do you use most?” open for some time now, but unfortunately there has been a very low level of participation, and therefore I now ask you to please participate and let us know what tools you are using!

Posted in Main | Tagged: , | 2 Comments »

Windows 7 – A promising thing when it comes to performance

Posted by Kim on Saturday, January 17, 2009

As soon as I was able to (the download surge killing Win7 downloads prevented it for a while) I downloaded and installed 2 copies of the Win7 beta. One was on an old 3GHz HT Intel with 2Gb mem and the other on a Virtual PC inside my QuadCore Vista ultimate machine.

The installation was smooth on both, took about the same time and I was amazed at the lack of problems along the way. Both recognized all hardware components without problems and everything seemed fast on the GFX level even when I was using a VGA mode for both (no seeing any GFX specialties).

I next installed Firebird v2.1 (latest stable) and it insalled without problems as well on both machines. I didn’t have much time to play around with the OS but the little I did showed me a stable well working system with very little or no hichups at all.

In my personal opinion this Win7 will be a hit-OS in the future. It feels fast and looks good and I see no reason for me to start looking into alternative OS’s in the future. If drivers and programs are made compatible with this Beta I suspect they will work well with the official release and if MS adds WinFS or other enhancements to it later they will likely not break the compatibility in any way.

I for one will surely use it in the future! And a s bonus it seems my Delphi 2009 programs are also working flawlessly on it!

Posted in Main | Tagged: , , , | Leave a Comment »

How users see a SAP EP Portal perform …

Posted by Kim on Friday, December 12, 2008

I recently had the opportunity to test a SAP Enterprise Portal (web interface) with several different tools. I used both LoadRunner and QALoad, but in the end the customer chose LR for this, since scripting was somewhat easier in LR.

The performance of the EP portal is fairly good when it comes to communicating with the server on a HTTP protocol level, but boy was the customer in for a surprise when they actually used the interface. Read the rest of this entry »

Posted in Main | Tagged: , , | Leave a Comment »

Apache Serves Images Slowly

Posted by Kim on Thursday, July 10, 2008

Today I had a really interesting and strange problem with the Apache WWW server. It served images very slowly under even light loads and there was really no explanation for this. The CPU on the host machine almost idle and network throughput was nominal too.

After some digging on the internet I found other people also had had this problem, and had suggested various methods to remedy this, like enabling caching and putting images on a separate machine and disabling the KeepAlive feature. Read the rest of this entry »

Posted in Main | Tagged: , , , , | 4 Comments »

Poor Processes yield Poor Performace

Posted by Kim on Friday, May 30, 2008

So here I am, sitting in a bar, at an airport, trying to figure out why my flight is over an hour late …

It occurs to me that the processes involved with flights are probably the cause of this, and it dawns on me that a poor process is as much a performance bottleneck as a poorly written piece of software is !!!

The flight was late, according to the lady at the counter, because it left late from the previous airfield. That was something I had figured out by myself, but this seemed to be a perfectly acceptable explanation for her. I of course wanted to know WHY the plane left later than scheduled, but that was something she could not help me with. Read the rest of this entry »

Posted in Main | Leave a Comment »

ScrumWorks SOAP API Test Results

Posted by Kim on Wednesday, May 14, 2008

I won’t go into the details of the specs of the hardware or OS, since there is no reliable way to compare two different systems against each other, but the relative performance on the tested system gives a very good insight as to how it will behave on other systems as well.

I also want to stress that the SOAP API is not the same as the web/desktop client, and may use a different communication model on the server side. The results ARE NOT comparable to the web or desktop client response times.

Read the rest of this entry »

Posted in Main | Tagged: , , | Leave a Comment »

The impact of Digital Signatures

Posted by Kim on Wednesday, May 7, 2008

I recently tested a service that had a Digital Signature system option. At first the Digital Signatures where not enabled, and we were happily testing and getting around 500 ms response times for the service.

Then the Digital Signatures where enabled, and we had to first sign the messages sent, then the server needed to verify the signatures as well.

This turned out to be a major CPU and TIME hog, since on average, regardless of load the verification of the signature took around 200 ms to perform. This made the allover response times increase to around 700 ms for each transaction (200 ms is around 28.5% of 700 ms!). Read the rest of this entry »

Posted in Main | Tagged: , , | Leave a Comment »

More on ScrumWorks Pro API testing

Posted by Kim on Wednesday, April 23, 2008

I today spent most of my time testing the ScrumWorks Pro 3.0 SOAP API, with the MySQL database, and came to the conclusion that there are some potential performance killers in the application.

The test data we used was somewhat larger than a typical small project. This data was scaled to match the expected data amounts of a very large enterprise environment within a few years, with lots of users. Read the rest of this entry »

Posted in Main | Tagged: , , | 1 Comment »

OpenSource PT tools lack in features

Posted by Kim on Tuesday, April 22, 2008

I’ve been investigating some of the OpenSource performance test tools available on the market, and it seems that most of them are lacking in features that are essential for performance testing in enterprise environments. A good list of both functional and performance tools can be found at

The biggest problem is that the tools are not designed to give out analyzable data in exported form, or even in viewable and understandable form on the screen. Read the rest of this entry »

Posted in Main | Tagged: , , | 2 Comments »

ScrumWorks Pro SOAP API

Posted by Kim on Saturday, April 5, 2008

The Scrumworks Pro product has an API that works using SOAP calls, and I needed to LoadTest the application using this interface.
I immediately had some problems with it since there seemed to be no documentation at all for non-Java developers. A had a JavaDoc that really didn’t tell me anything (as I’m not a Java developer), and the only raw SOAP example I had was one Danube’s support sent me, which didn’t work for me as it was meant for other tools than LoadRunner … Read the rest of this entry »

Posted in Main | Tagged: , , | 3 Comments »

Performance Testing Blog – And so it begins

Posted by Kim on Saturday, April 5, 2008

Today it begins, my Performance Testing and Performance Engineering blog, where I’ll outline some of the things I will encounter in this field…

I hope this is going to be a fun and informative place for all of you, but only time and your feedback can determine that!

Helpful tools

The tools I use mostly at work is LoadRunner from HP, but I also use a myriad of other utilities that assist me. The one biggest helpful “utility” i use is probably  Delphi, since I can make DLL’s and custom made applications that assist me in the testing process.

Also PHP and Apache are valuable help, since most of my testing is web based. Other very useful tools are WireShark (Network Analyzer) and FireBug (Firefox plugin, HTML analysis).

Posted in Main | Tagged: , , , | Leave a Comment »