More Apache+PHP+Firebird Performance results

Adding to my previous post on Apache, PHP and Firebird performance I have now achieved a new higscore of 155 pages/sec!

In order to achieve this I had to tweak the SQL statements a little (removed the UPPER() parts), modified the firebird.conf a little and moved the DB to another T61p (DualCore 2.2 GHz) machine.

The peak performance was:

  • Avg. 155 pages/sec
  • Avg. 230 hits/sec
  • Avg. Response times < 500ms
  • Avg. 95% CPU usage on WebServer
    • Lenovo T61p, 2.2 GHz DualCore, Windows XP SP2
    • Apache/2.2.9 (Win32) PHP/5.2.6
  • Avg. 48% CPU usage on DB serve
    • Lenovo T61p, 2.2 GHz DualCore, Windows XP SP2
    • Firebird v2.5 Aplha 1

Apache httpd.conf modifications

The following where changed in the httpd.conf file:

  • KeepAlive Off
  • ThreadsPerChild 250
  • Win32DisableAcceptEx

Firebird.conf modifications

The following where changed in the firebird.conf file:

  • TcpRemoteBufferSize = 32767
  • LockHashSlots = 3001
  • CpuAffinityMask = 3

Conclusions

All in all I think the Apache+PHP+Firebird combination is performing extremely well under load. The test scripts do a Login, 20xBrowse pages and Logout, and all these operations cause multiple reads/writes to the database.

I’ve seen many applications perform much worse on much better hardware. The results I have got are with default settings, except for those that I mentioned above, on desktop grade machines – Not too bad I’d say.

Advertisements

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