Since I run two PHP-Nuke based sites, MacMegasite and WorldBeatPlanet, I’ve been looking for ways to improve the performance of PHP Nuke, since it can be slow at times.
One very easy improvement I found was in the file sql_layer.php. Nuke uses that module as a wrapper to interface with several different databases. Every SQL call goes through a switch statement which tests the database type and executes the appropriate code. Since I’m only using MySQL, I’ve eliminated all of those switch statements and each function now just calls MySQL directly. I’ll be looking for other places I can optimize the code.