One of the performance hits that the GrabPERF system has is the dynamic generation of the main page. The nature of the SQL calls and the underlying PHP makes it scale exponentially past a certain number of measurements.

Last night, Kevin Burton made a grand suggestion: generate a static page on a regular schedule.

Duh!

Today, I wrote the script that does this. The performance of the main page has adjusted accordingly.

Yikes!

UPDATE: Ian Holsman reminded that if I use cURL, I can use the exiting PHP to build the pages without a PERL script.

I. AM. AN. IDIOT.

Now, bedtime.

Technorati Tags: GrabPERF, Web+performance, PHP, MySQL, Dynamic+pages, Static+pages, HTML

Related Posts

• GrabPERF: State of the System, Feb 2006
• Living with Bipolar: If you could press a button and be cured, would you?
• Performance Improvement From Caching and Compression
• GrabPERF: Compression Performance Study, Early Results
• GrabPERF Site Statistics | Web Analytics Index – Mar 08 2006