Firebird v2.5 Alpha 1 really makes a differance

While on vacation I’ve been working on a pet-project that has been around for many years now. The service is a mobile device chat and is powered by Firebird and PHP.

There used to be lots of problems handling more than 400 simultaneous users, but after a DB upgrade to Firebird v2.5 Alpha 1 things really look different.

Previously the DB machine (Dualcore) had one of the CPU’s running at 100% and the other not doing much (FB was Superserver) but after the switch the TOTAL CPU now ranges between 10% and 50% on the DB machine. At the same time the WebServer CPU load also decreased and is constantly under 60% where it used to be over 95% all the time!

So by just switching to the new DB engine a tremendous performance gain was achieved! Also a lot less errors are reported to the PHP error logs. The ones still coming are a deadlocks, but around 30 / 24h which is a lot less than it used to be!

To the Firebird team I want to say “THANK YOU for making a great database engine” !

Advertisements

14 thoughts on “Firebird v2.5 Alpha 1 really makes a differance

  1. I’m not the admin of the environment where it was running, and other versions of Firebird hadn’t worked as expected, so the admin was reluctant to try the classic one.

    If I ever get him talked into trying a classic version I will definetly post the results here!

  2. Firebird v2.5 introduces a new “SuperClassic” operational mode, which is addition to the previous “SuperServer” and “Classic”. Can you confirm which mode the server is running.

  3. @Sean: The installation package was downloaded from IBPhoenix (11th Jul 2008 SuperServer and Classic for Windows (.exe) (7.0mb)) and during installation the option SUPERSERVER was selected. The SuperClassic mode you mention was not listed in the options, only classic and superserver. The version of FB in as DBW shows it is: “WI-T6.3.0.20343 Firebird 2.5 Alpha 1” (interesting to see that it says 3.0.20343!).

  4. whoah this weblog is great i really like studying
    your articles. Stay up the good work! You recognize, a lot of individuals
    are hunting round for this info, you could aid them greatly.

  5. Just wish to say your article is as surprising. The clearness in your post
    is simply cool and i can assume you’re an expert on this subject.
    Fine with your permission allow me to grab your RSS feed to keep
    updated with forthcoming post. Thanks a million and please keep up the gratifying work.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s