DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Discuss the FAQ's here, and get in touch with the FAQ Team.
Post Reply
Geoff
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3193
Joined: Sun Apr 16, 2006 12:20 am
Location: 127.0.0.1

DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by Geoff » Thu Aug 24, 2006 10:13 pm

This is the discussion topic for "Tuing for Speed with PHP5 and MySQL 5" located here: http://forum.joomla.org/index.php/topic,88070.
Backup, backup, backup!
The "Master" .htacess file by Nicholas http://snipt.net/nikosdion/the-master-htaccess

welby
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Fri Feb 10, 2006 3:43 pm

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by welby » Tue Sep 12, 2006 2:17 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Dec 01, 2005 4:38 pm
Location: Belgium
Contact:

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by thematrix » Wed Sep 13, 2006 11:22 am

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.
Last edited by thematrix on Wed Sep 13, 2006 11:25 am, edited 1 time in total.

rmd
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 233
Joined: Sat Feb 18, 2006 3:31 pm

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by rmd » Fri Sep 15, 2006 4:44 pm

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

thematrix
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Dec 01, 2005 4:38 pm
Location: Belgium
Contact:

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by thematrix » Fri Sep 15, 2006 4:48 pm

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
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 233
Joined: Sat Feb 18, 2006 3:31 pm

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by rmd » Fri Sep 15, 2006 4:57 pm

Thanks, and this host doesn't have either.  :(

thematrix
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Dec 01, 2005 4:38 pm
Location: Belgium
Contact:

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by thematrix » Fri Sep 15, 2006 5:40 pm

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

rmd
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 233
Joined: Sat Feb 18, 2006 3:31 pm

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by rmd » Fri Sep 15, 2006 5:45 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 36
Joined: Sun Jan 28, 2007 8:49 pm
Location: San Diego
Contact:

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by dougg » Sun Jan 28, 2007 9:01 pm

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

User avatar
Jason
Joomla! Intern
Joomla! Intern
Posts: 70
Joined: Sat Aug 20, 2005 7:08 am
Location: Midwest, USA
Contact:

Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5

Post by Jason » Mon Aug 20, 2007 6:10 pm

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.
web standards and usability expert


Post Reply

Return to “FAQ Discussion Board”