Alex Little

Eventually tracked down the issue with the headers – they were being automatically set by Apache and had been set to have KeepAlive off (apparently that’s the default for Apache on RedHat, but default for Apache generally is KeepAlive on). Once we’d set this up correctly there aren’t loads of open connections left open on the server (the same connection is used for multiple requests), the performance has significantly improved.

The other area I’m looking at too try and speed things up is to replace the proxy library that I’m using which downloads the data from the MSG server. I’m currently using fsockopen and fread to download the data, but I’m looking to replace this with cURL – which is apparently much quicker….

I’ve just got my new laptop so am getting all the bits and bobs installed on here that I’ll need for the OCI work. I’m going through the process of installing Apache, MySQL, PHP etc (I’d prefer to do this myself than to use one of the all-in-one installers, just so I know how it all really works!). nearly there with it now, just a couple of things I noticed on various forums etc about getting PHP5 to work with Apache 2.2, a fair few forum postings mention downloading php5apache2_2.dll to use instead of php5apache2.dll. I found that I didn’t need to do this, and instead of adding a LoadModule command to the Apache httpd.conf file, I just added this at the end instead:

ScriptAlias /php/ “c:/PHP/”

AddType application/x-httpd-php .php .php5

Action application/x-httpd-php “/php/php-cgi.exe”

SetEnv PHPRC “C:/php”

I then also needed to update the directory security section in the httpd.conf file too, to allow Apache access to the PHP directory.

For info, this was the best tutorial I found for getting all this set up – although it’s for MySQL 4.1, it still holds for MySQL 5.