Optimizing queries with MySQL EXPLAIN

The MySQL explain command is one of the most useful commands when debugging or optimizing queries on MySQL. It will tell you how MySQL is processing that data it needs to run your query. To use the command, simply put EXPLAIN (or EXPLAIN EXTENDED) in front of your query. For each table (or derived table), […]

Run multiple versions of PHP using fcgid and suexec

Run multiple versions of PHP using fcgid and suexec

When hosting multiple sites on the same server, you sometimes might just want to be able to run different versions of PHP. Add multiple users to the problem (like in a typical shared hosting environment) and you probably might also want to prevent a user from accessing files of another user. You may also want […]

Efficient data processing in PHP

Last weekend, I was at PHP Benelux and attended a talk of Juozas Kaziuk─Śnas titled “Process any amounts of data. Any time”. What it comes down to, is that by using the right techniques, you could process virtually any amount of data without killing your webserver. The thing is, the talk did not really teach […]