DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

[Geoff]

This is the discussion topic for "Tuing for Speed with PHP5 and MySQL 5" located here: http://forum.joomla.org/index.php/topic,88070.

[welby]

Hi, thank you for the information.

I was wondering if you could recommend a good php accelerator that is opensource/free?

I know of Zend but this is for zend encoded php.

The setting of mysql cache settings does not make massive increases in speed.

I would also be interested if there and tools that can look at your weburl and give you a detailed report as to the efficiency your code is?

Thanks

[thematrix]

For caching and zipping, check Port80software.com, they have online checks for both content cache settings and page compression statistics.

For profiling code, I guess your best of using a good development suite like Eclipse with the PHP extensions and setting+checking MySQL slow query logs and such.

Zend Performance suite also has built in tools for PHP and SQL performance profiling.

For Windows, you can get the Performance suite for free for development purpouses, don't know about the Linux version.

Also, for IIS, you don't need to use a script like that to compress CSS and JS scripts, you can add that to the metabase.

[rmd]

How do I check a shared hosting server to see what they have installed for PHP caching?

[thematrix]

create a file "info.php" with the following code:



and goto to it with your browser.

If you can't find any mention of eaccelerator or APC on that page, it isn't installed.

[rmd]

Thanks, and this host doesn't have either. 

[thematrix]

If the server is setup right you don't even need a cacher.

[rmd]

I have to say that I am no server admin (like that wasn't apparent? :P lol) but I would not doubt if the server is not set up with optimum performance in mind. But nothing I can do about who the client chooses to host with...just try to make the best with what I am given, and hope to convince them otherwise down the road.

[dougg]

I went to port80software.com and discovered that my Joomla's site can definitely benefit from compression / cacheing, etc.

I downloaded the httpzip app (free trial) but I am not sure how to install it on my site....I don't own the server where the site is hosted, so I am not sure how I would run it on my hosting account....Same with the other apps that port80 offers. Can anyone shed light on this for me? I am afraid of just ftp'ing the zip.exe to my root directory and double-clicking to execute it...(if that would even work..) it makes me nervous. I just recently had a site scrambled by running a so-called patch and I don't want to re-live the experience of doing a fresh install of a CMS and re-creating the content.

Any help will be appreciated,
Dougg

[Jason]

For the 4th step, how would you include this?

In the head area would you do a simple include_once to a php file?

Ex:

Code: Select all

<?php include_once(css_js.php); ?>

Thanks.