Caps wrote:Need to optimize PHP as a CMS script is has slow page loads. I am instructed to use Zend Optimizer for Windows. Do I just install the exe file?
I believe and stand to be corrected, but does not CMSs and other similar scripts rely heavily on massive multiple MySQL database accesses, which must use plenty of system resources?
Now one way of helping MySQL use your system resources efficiently is to use the correct my.ini file whose settings reflect your system's resources, RAM etc.
You will find in XAMPP version 1.7.4> located In the \xampp\mysql folder pre constructed 5 pre constructed my*.ini files.
Each one of these has settings that use more or less system resources to effectively influence performance of high use database access.
The comments in each file will give an indication of how each of these my*.ini file has been constructed.
The my.ini file in the \xampp\mysql\bin folder in the default XAMPP installation uses 'small' settings for low end systems and so has a limiting or throttling effect if you have a high end PC with lots of RAM etc.
So all you need do is rename the my.ini to my_original.ini for example, then go through those other 5 in the mysql folder by copying one at a time and renaming it to my.ini file and see which one best suits or shows the best performance improvement - remember to restart MySQL and Apache after each change of my.ini file.
I hope this helps with even some small improvement for what must be a frustrating issue and may be a little quicker and a 'first try this' approach rather than trying to find a zend alternative which may only have a limited effect.