Good PHP Code

imnsi

I wanted to make sure that we were freeing up as many resources on our server as possible. We have about 20 sites all using php/mysql. What are some good tips to free up RAM, make the sites run smooth, we are starting to see some lag. Is there anything I can do in the code (or at the end of each script) to free up ram?

krotkruton

Not sure if this is what you are looking for, but I keep reading that it is important to only use in mysql queries when you really need every column of a row. For queries where you only need one column of a table, it is really bad to use . That might be something much more basic than you are looking for, but it's kinda hard to know where to start.

RyanJones

If your are using lots of arrays make shure to unload them usin the unset() function.

Set any un-needed classes to null once you have finished with them.

Other things like ohnly having the bare minimum inside loops and things like that also help :-)

Cheers,

Ryan Jones

MarkR

It's not necessary to free up variables manually at the end of the script's execution. PHP always does that anyway.

If you're using Apache on Unix, if you build it with the threaded MPM (worker) rather than the prefork MPM (prefork), memory consumption is significantly less.

It will of course force you to rebuild PHP and have a thread-aware PHP, but remember, this is not that unusual - Win32 Apache/IIS users have it permanently in this mode.

Using the worker MPM will improve Apache's memory usage significantly, particularly if you have a very busy site.

Another thing to bear in mind is persistent mysql database connections - these are not really helpful if you have a large number of small sites (particularly if the database server is local) - they just increase memory consumption without affecting performance - so disable persistent connections.

Mark