Performance Testing @ the Frontline

A hidden world where small things make a big difference

Firebird v2.5 Alpha 1 really makes a differance

Posted by Kim on Wednesday, August 27, 2008

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 Responses to “Firebird v2.5 Alpha 1 really makes a differance”

  1. […] more than 400 simultaneous users, but after a DB upgrade to Firebird v2.5 Alpha 1 things really look different. Permalink |                     […]

  2. pabloj said

    Why didn’t you use Classic server on a multiprocessor machine? It could use both CPUs instead of just one.
    That would be an interesting comparison

  3. Kim said

    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!

  4. Sean said

    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.

  5. Kim said

    @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!).

  6. sandrar said

    Hi! I was surfing and found your blog post… nice! I love your blog. 🙂 Cheers! Sandra. R.

  7. Sign: wdpad Hello!!! upcfx and 7303ythxgznauf and 1966 : Cooooool blog really

  8. Hello, all is going well here and ofcourse every one
    is sharing facts, that’s genuinely fine, keep up writing.

  9. Hi to all, the contents present at this web page are in fact remarkable for people experience, well, keep up the good work fellows.

  10. It’s amazing in support of me to have a web site, which is helpful
    in support of my experience. thanks admin

  11. Amanda said

    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.

  12. Usually I do not learn article on blogs, but I wish to say that this write-up very forced me to
    try and do so! Your writing style has been surprised me.

    Thanks, quite great post.

  13. trancheuse said

    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.

  14. Good post! We are linking to this great article on our site.
    Keep up the great writing.

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

 
%d bloggers like this: