Speed Joomla Up
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security and Performance FAQs
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security and Performance FAQs
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
-
- Joomla! Enthusiast
- Posts: 215
- Joined: Tue Oct 04, 2005 6:06 pm
Speed Joomla Up
Ok,
(Mods maybe this topic could be pinned for people to add to)
A few tips to speed up your front end :
- Optimize all your images for the web, most should come in at under 10kb. This will reduce your overall page size and mean that users on a slower connection can visit your site faster.
- Remove "white space" from your template index.php file, all those esxtra white lines are doing nothing other than wasting bandwidth and meaning that Joomla takes longer to display. Remember the longer your site takes to load, the less people that will visit it, and stay reading for a beneficial amount of time.
- Optimize your Css, remove un-needed stuff that does not get used. Then run it through - http://flumpcakes.co.uk/css/optimiser/ . This will have the effect of tidying it all up and making it small, again reducing load times and also your overall bandwidth.
- Sort out your database, go into phpMyAdmin and select all the tables and repair and then optomise them. This will not damage your site and again it will make your pages load in a much quicker fashion.
If people have more tips then please add them below. The ones that I have added are just a sprinkling of things that you can do with Joomla to get it running faster.
(Mods maybe this topic could be pinned for people to add to)
A few tips to speed up your front end :
- Optimize all your images for the web, most should come in at under 10kb. This will reduce your overall page size and mean that users on a slower connection can visit your site faster.
- Remove "white space" from your template index.php file, all those esxtra white lines are doing nothing other than wasting bandwidth and meaning that Joomla takes longer to display. Remember the longer your site takes to load, the less people that will visit it, and stay reading for a beneficial amount of time.
- Optimize your Css, remove un-needed stuff that does not get used. Then run it through - http://flumpcakes.co.uk/css/optimiser/ . This will have the effect of tidying it all up and making it small, again reducing load times and also your overall bandwidth.
- Sort out your database, go into phpMyAdmin and select all the tables and repair and then optomise them. This will not damage your site and again it will make your pages load in a much quicker fashion.
If people have more tips then please add them below. The ones that I have added are just a sprinkling of things that you can do with Joomla to get it running faster.
-
- Joomla! Explorer
- Posts: 341
- Joined: Fri Aug 26, 2005 7:10 pm
Re: Speed Joomla Up
Those are all good points 3guk, but they apply to speeding up any website and not necessarily to optimizing Joomla. To improve the speed of Joomla's delivery is to change the source code itself.
One way to speed up Joomla (or any other CMS with as many options) is just to utilize fewer of the features. Many people see all the different features that are standard to Joomla and they immediately publish all of them. My first Joomla based site had the random image module, most popular, polls, and probably a few other features it did not need. This problem is one of site design and in my case I have been able to calm down over the past couple years and make a slimmer site that still seems to convey more information than the original. Publishing fewer modules or having fewer features enabled decreases the number of database inquires and reduces the amount of php code that must be processed for any given web page.
Sometimes, less is more, which is a cliche but still a valid point.
One way to speed up Joomla (or any other CMS with as many options) is just to utilize fewer of the features. Many people see all the different features that are standard to Joomla and they immediately publish all of them. My first Joomla based site had the random image module, most popular, polls, and probably a few other features it did not need. This problem is one of site design and in my case I have been able to calm down over the past couple years and make a slimmer site that still seems to convey more information than the original. Publishing fewer modules or having fewer features enabled decreases the number of database inquires and reduces the amount of php code that must be processed for any given web page.
Sometimes, less is more, which is a cliche but still a valid point.
-
- Joomla! Enthusiast
- Posts: 215
- Joined: Tue Oct 04, 2005 6:06 pm
Re: Speed Joomla Up
Thats a good point, I disabled loads of extras that I did not need. I will be delving into the code over the next few weeks in order to get joomla running faster and faster.
Thats where I hope this topic is going.
Thats where I hope this topic is going.
- Hackwar
- Joomla! Virtuoso
- Posts: 3788
- Joined: Fri Sep 16, 2005 8:41 pm
- Location: NRW - Germany
- Contact:
Re: Speed Joomla Up
Although these tips are for websites in generel, they also mean A LOT of optimizations for Joomla. Don't underestimate this.
A few tips from me:
General:
Watch out for errors in your template. When you reference a file like arrow.gif and this file is non-existent, the performance of your server will drop immensly.
Take a look here and check for your websites performance:
www.websiteoptimization.com/services/analyze/
This page gives you a summary about your websites objects and has proposals how to improve it.
Joomla specific:
If your server has performance problems, don't enable gzip. This is meant to reduce the usage of bandwith, not the load on your server. The server has to encode all the files in order to send them, which only puts additional load on your page.
If you encounter serious problems and you have SEF enabled, disable it. It's often the source for performance problems
Probably most important of all: Keep your Joomla! version up-to-date! As to this moment, Joomla 1.0.8 is the most recent version and besides the security fixes, there are big performance improvements, that can save up to half of the queries necessary for a page. This has been implemented in 1.0.8!
A few tips from me:
General:
Watch out for errors in your template. When you reference a file like arrow.gif and this file is non-existent, the performance of your server will drop immensly.
Take a look here and check for your websites performance:
www.websiteoptimization.com/services/analyze/
This page gives you a summary about your websites objects and has proposals how to improve it.
Joomla specific:
If your server has performance problems, don't enable gzip. This is meant to reduce the usage of bandwith, not the load on your server. The server has to encode all the files in order to send them, which only puts additional load on your page.
If you encounter serious problems and you have SEF enabled, disable it. It's often the source for performance problems
Probably most important of all: Keep your Joomla! version up-to-date! As to this moment, Joomla 1.0.8 is the most recent version and besides the security fixes, there are big performance improvements, that can save up to half of the queries necessary for a page. This has been implemented in 1.0.8!
god doesn't play dice with the universe. not after that drunken night with the devil where he lost classical mechanics in a game of craps.
Since the creation of the Internet, the Earth's rotation has been fueled, primarily, by the collective spinning of English teachers in their graves.
Since the creation of the Internet, the Earth's rotation has been fueled, primarily, by the collective spinning of English teachers in their graves.
- DeanMarshall
- Joomla! Hero
- Posts: 2352
- Joined: Fri Aug 19, 2005 2:26 am
- Location: Lancaster, Lancashire, United Kingdom
- Contact:
Re: Speed Joomla Up
On the subject of CSS you can force compression and caching by using a bit of code like this at the start of your Stylesheet:
Save your template as template_css.php and edit the reference to the template in /templates//index.php to reflect the new name
As Hackwar said above don't force compression if your server is overloaded - but if it is not, go for it.
The normal rule of thumb with a web server is to worry about how long it is stressed, not how stressed it is.
Serving compressed content is often quicker than tying up the server for a longer period serving uncompressed content - but it varies from server to server.
Just to reiterate Hackwars comments about SEF and missing files (especially template images) with older versions of Joomla and $ambo, especially if you are using an older .htaccess file, if you have upgraded Joomla but not the .htaccess file then you should take a look at the newer htaccess files.
Dean
Code: Select all
<?php
ob_start ("ob_gzhandler");
header("Content-type: text/css");
header("Cache-Control: must-revalidate");
$offset = 60 * 60 * 24 * 7 ;
$ExpStr = "Expires: " .
gmdate("D, d M Y H:i:s",
time() + $offset) . " GMT";
header($ExpStr);
?>
... rest of style sheet as normal here ...
Code: Select all
<link rel="stylesheet" href="/templates/<name-of-template>/css/template_css.php" />
The normal rule of thumb with a web server is to worry about how long it is stressed, not how stressed it is.
Serving compressed content is often quicker than tying up the server for a longer period serving uncompressed content - but it varies from server to server.
Just to reiterate Hackwars comments about SEF and missing files (especially template images) with older versions of Joomla and $ambo, especially if you are using an older .htaccess file, if you have upgraded Joomla but not the .htaccess file then you should take a look at the newer htaccess files.
Dean
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/
Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
- Tom
- Joomla! Enthusiast
- Posts: 104
- Joined: Thu Aug 18, 2005 1:08 pm
- Location: Cleveland, OH
- Contact:
Re: Speed Joomla Up
Also, if you have root access, install a PHP accelerator like APC. This server is running APC and serves up more pages than you want to even think about, but it handles it gracefully thanks to APC.
-
- Joomla! Enthusiast
- Posts: 141
- Joined: Wed Sep 07, 2005 5:18 pm
- Location: The Netherlands
- Contact:
Re: Speed Joomla Up
And remember to save your old css somewhere, because you cannot easily edit the optimized one.
Also enable query caching in your mysql server! Save ALOT!
Check with debug site if you have any unnessesary queries and also try to reduce the amount of queries! especialy for your frontpage.
Put error reporting to full and check for errors
Install HttpWatch for IE and check if all the images are present and check what takes longer then other stuf.. (you can also compare your preformance with this, for ex. if you optimize your css check if it really loads faster now)
Enable caching in joomla
Compare if your server runs better with gzip enabled of disabled. For a very busy site its sometimes much better to leave it off.
Also enable query caching in your mysql server! Save ALOT!
Check with debug site if you have any unnessesary queries and also try to reduce the amount of queries! especialy for your frontpage.
Put error reporting to full and check for errors
Install HttpWatch for IE and check if all the images are present and check what takes longer then other stuf.. (you can also compare your preformance with this, for ex. if you optimize your css check if it really loads faster now)
Enable caching in joomla
Compare if your server runs better with gzip enabled of disabled. For a very busy site its sometimes much better to leave it off.
Signature rules: http://forum.joomla.org/index.php/topic,65.0.html
Only exact url's allowed
Only exact url's allowed
-
- Joomla! Intern
- Posts: 64
- Joined: Fri Mar 10, 2006 11:12 am
- Location: Spain
Re: Speed Joomla Up
Thanks. It's a great help for optimizations.Hackwar wrote:
Take a look here and check for your websites performance:
www.websiteoptimization.com/services/analyze/
This page gives you a summary about your websites objects and has proposals how to improve it.
Believe in you,believe in Joomla
-
- Joomla! Intern
- Posts: 75
- Joined: Thu Aug 18, 2005 8:13 pm
- Location: Tulsa, OK
- Contact:
Re: Speed Joomla Up
Actually the best way to gzip your css is just to create a file named 'template_css.php' and add the following code into it:
Then change your template to reflect the name as stated before:
That way you can still edit your css file through the admin panel.
Code: Select all
<?php
ob_start ("ob_gzhandler");
header("Content-type: text/css");
header("Cache-Control: must-revalidate");
$offset = 60 * 60 ;
$ExpStr = "Expires: " .
gmdate("D, d M Y H:i:s",
time() + $offset) . " GMT";
header($ExpStr);
?>
<?php include ('template_css.css'); ?>
Code: Select all
<link rel="stylesheet" href="/templates/<name-of-template>/css/template_css.php" />
"You make a living by what you get, You make a life by what you give." -Winston Churchill
http://www.churchministriesonline.com
http://www.churchministriesonline.com
-
- Joomla! Enthusiast
- Posts: 127
- Joined: Thu Oct 06, 2005 2:07 pm
Re: Speed Joomla Up
I have created the file templatecss.php but I didn't understand what to do with the command
Do I have to insert it into the template.css file?
Thanks,
Luigi
Code: Select all
<link rel="stylesheet" href="/templates/<name-of-template>/css/template_css.php" />
Thanks,
Luigi
-
- Joomla! Enthusiast
- Posts: 215
- Joined: Tue Oct 04, 2005 6:06 pm
Re: Speed Joomla Up
Nope, put it in your index.template.html file, replacing the Link rel that links to the .css version.
-
- Joomla! Enthusiast
- Posts: 127
- Joined: Thu Oct 06, 2005 2:07 pm
Re: Speed Joomla Up
Thank you for your reply. Unfortunately, I do not have a index.template.html file. I just have an index.php and the css file.
- DeanMarshall
- Joomla! Hero
- Posts: 2352
- Joined: Fri Aug 19, 2005 2:26 am
- Location: Lancaster, Lancashire, United Kingdom
- Contact:
Re: Speed Joomla Up
/templates//index.php
Where:
is a placeholder for the actual location of your joomla installation.
is a placeholder for the specific subfolder for your current template.
Dean
Where:
is a placeholder for the actual location of your joomla installation.
is a placeholder for the specific subfolder for your current template.
Dean
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/
Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
-
- Joomla! Intern
- Posts: 75
- Joined: Thu Aug 18, 2005 8:13 pm
- Location: Tulsa, OK
- Contact:
Re: Speed Joomla Up
Yes this goes in your index.php file in place of the original css link in the head.lboccia wrote: Thank you for your reply. Unfortunately, I do not have a index.template.html file. I just have an index.php and the css file.
"You make a living by what you get, You make a life by what you give." -Winston Churchill
http://www.churchministriesonline.com
http://www.churchministriesonline.com
-
- Joomla! Intern
- Posts: 74
- Joined: Tue Jul 11, 2006 8:17 pm
Grafik Optimizing
For Grafik Optimizing I use:
WebGraphics Optimizer from http://www.webopt.com/
I doesn´t know a better software. For a best result you sould read the manual. See the example in this Programm and play a little with it...
Normaly a 500KB File can be "shrinked" to 180-100KB
WebGraphics Optimizer from http://www.webopt.com/
I doesn´t know a better software. For a best result you sould read the manual. See the example in this Programm and play a little with it...
Normaly a 500KB File can be "shrinked" to 180-100KB
- dionysus
- Joomla! Enthusiast
- Posts: 199
- Joined: Tue Dec 13, 2005 10:57 am
- Location: Los Angeles
Re: Speed Joomla Up
This was posted on the Rockettheme forum.
Just wanted your opinion:
"FYI, turning the css into a php file probalby will not speed up your site, infact it will probalby slow it down. All browsers cache css files automatically, so this means they aer only downloaded once. By converting it into php, even a cached php file, the server has to process it and sends a fresh copy everytime."
Just wanted your opinion:
"FYI, turning the css into a php file probalby will not speed up your site, infact it will probalby slow it down. All browsers cache css files automatically, so this means they aer only downloaded once. By converting it into php, even a cached php file, the server has to process it and sends a fresh copy everytime."
-------------------------------------------
Joomla 3.1
Joomla 3.1
-
- Joomla! Guru
- Posts: 903
- Joined: Fri Apr 07, 2006 2:36 pm
- Location: UK
- Contact:
Re: Speed Joomla Up
Browsers can happily cache gzipped css files, which is what the PHP script outputs, so it doesn't matter whether you compress it or not. The difference is made on the first site load by the browser - if the CSS is gzipped, the initial download is smaller, and hence the page appears faster. Once it has the initial download, it'll be cached, so it won't be downloaded again unless your css changes, exactly as if you'd served an uncompressed css file.
I'd say that gzipping would make little difference for regular visitors, but for first time visitors, a site using css compression is going to appear faster than one without. It all depends on whether you are aiming at repeat visitors or building new traffic.
I'd say that gzipping would make little difference for regular visitors, but for first time visitors, a site using css compression is going to appear faster than one without. It all depends on whether you are aiming at repeat visitors or building new traffic.
FlexAdvert - the _improved_ Banner Management Suite. Find it at extensions.joomla.org under Advertising Banners
Bleurgh Joomla Extensions - http://www.bleurgh.co.uk - usage instructions, updates and so on
Performance FAQ: http://forum.joomla.org/index.php/topic,88070.0.html
Bleurgh Joomla Extensions - http://www.bleurgh.co.uk - usage instructions, updates and so on
Performance FAQ: http://forum.joomla.org/index.php/topic,88070.0.html
-
- Joomla! Apprentice
- Posts: 46
- Joined: Wed Aug 30, 2006 12:22 pm
Re: Speed Joomla Up
Compressed CSS is better for server load than uncompressed CSS?
-
- Joomla! Guru
- Posts: 903
- Joined: Fri Apr 07, 2006 2:36 pm
- Location: UK
- Contact:
Re: Speed Joomla Up
Not really - it uses a bit of CPU load to compress it, but, if you've got caching set up, it can store the compressed version and serve that up if the browser can handle it. What it saves is bandwidth: compressed files don't need to transfer as much data across, so if you're on a very bandwidth limited server, or if your users are impatient, the compressed version will appear faster.
As CPU tends to be "cheaper" than bandwidth, unless you're pushing the CPU usage on your server already, adding CSS compression will add a very small hit to the CPU usage which shouldn't affect your load much, but can save you quite a bit on bandwidth (especially if you have lots of CSS files).
As CPU tends to be "cheaper" than bandwidth, unless you're pushing the CPU usage on your server already, adding CSS compression will add a very small hit to the CPU usage which shouldn't affect your load much, but can save you quite a bit on bandwidth (especially if you have lots of CSS files).
FlexAdvert - the _improved_ Banner Management Suite. Find it at extensions.joomla.org under Advertising Banners
Bleurgh Joomla Extensions - http://www.bleurgh.co.uk - usage instructions, updates and so on
Performance FAQ: http://forum.joomla.org/index.php/topic,88070.0.html
Bleurgh Joomla Extensions - http://www.bleurgh.co.uk - usage instructions, updates and so on
Performance FAQ: http://forum.joomla.org/index.php/topic,88070.0.html
-
- Joomla! Intern
- Posts: 79
- Joined: Wed Aug 23, 2006 4:17 am
Re: Speed Joomla Up
css? common now, everyone is grabbing onto a few 100k of file as a usual suspect beause it is 'easy'.
CSS will not speed up anything in global scale of things...this is for the most part dealt by the clinets/browsers and in 99% of cases it is cached...using server side language to produce css is waste of everything Unless you are using SS to produce dynamic css that are different from page to page...often seen in 'site builders' and even so ones the file is produced it should be 1 time process and result.css saved somewhere on the server...can you say SSI or perhaps Import?Link?...which is what can be found on idex.php
We need to look in direction of the 3-tier ...being that client side is covered...
You can optimise your images and css decorations all you want....(and it helps don't get me wrong) but your bread is made by:
-improved server side code and processes (in this case php or core of Joomla itself..u get what u code yourself or keep the faith in J developers)
-optimised database server (mysql...stored procedures,cached and reused querries,less sessions and dynamic vars...
If any one is running on 'shared' host that provides "unlimited mySQL databses"....ha well guess how many crappy structured DBs can there be on the same server.
You want something faster than the other guy....?
1. dedicated and optimised servers with enough bandwith
2. write your code from scratch...
...and here comes the wrath of Joomla lovers
CSS will not speed up anything in global scale of things...this is for the most part dealt by the clinets/browsers and in 99% of cases it is cached...using server side language to produce css is waste of everything Unless you are using SS to produce dynamic css that are different from page to page...often seen in 'site builders' and even so ones the file is produced it should be 1 time process and result.css saved somewhere on the server...can you say SSI or perhaps Import?Link?...which is what can be found on idex.php
We need to look in direction of the 3-tier ...being that client side is covered...
You can optimise your images and css decorations all you want....(and it helps don't get me wrong) but your bread is made by:
-improved server side code and processes (in this case php or core of Joomla itself..u get what u code yourself or keep the faith in J developers)
-optimised database server (mysql...stored procedures,cached and reused querries,less sessions and dynamic vars...
If any one is running on 'shared' host that provides "unlimited mySQL databses"....ha well guess how many crappy structured DBs can there be on the same server.
You want something faster than the other guy....?
1. dedicated and optimised servers with enough bandwith
2. write your code from scratch...
...and here comes the wrath of Joomla lovers
- DeanMarshall
- Joomla! Hero
- Posts: 2352
- Joined: Fri Aug 19, 2005 2:26 am
- Location: Lancaster, Lancashire, United Kingdom
- Contact:
Re: Speed Joomla Up
Well yes - partly. And because it works.css? common now, everyone is grabbing onto a few 100k of file as a usual suspect beause it is 'easy'.
Most threads about speeding up a site will concentrate on the INITIAL page load - ie the first page that a new visitor sees (first impressions and all that). Subsequent pages are usually significantly faster due to caching of images, .js files and .css files.
Gzipping of ouptut html as well as other text files can indeed produce very noticeable speed increases - probably far more noticeable to the end user (site visitor) than speeding up the database server from .2 of a second to .1 of a second. For the majority of users the download is the bottleneck - reducing 100KB of css to 5 or 10KB has significant benefits.
If a database server (or the webserver itself) is particularly overloaded and is the bottleneck then forget what I said above - some other course of action such as those you propose will be required.
Dean
Dean Marshall Consultancy - six Joomla experts - http://www.deanmarshall.co.uk/
Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
Joomla Experts - Joomla Support http://www.deanmarshall.co.uk/joomla-se ... pport.html
-
- Joomla! Intern
- Posts: 79
- Joined: Wed Aug 23, 2006 4:17 am
Re: Speed Joomla Up
Agreed Dean,
One experience that I can share that blew me away (as an admin not a dba) was powered by Sybase (belive v 9 at the time).
You are right no website really has that many records to see the difference - talking about 'content' based sites...but on those that are transaction & multimedia heavy I have seen difference as large as 10 sec. vs. 3 sec. of returned results. Also, have seen the very same databse lock up with alternaitve version of the same querry. "Transaction table" had about 60-70 fields and little over 3 mil. of records. nothing embeded.
Anyhow...ever since I am a beliver of taking extra time to optimise the DB.....now If I had the skills I would be set
Thanks for letting me rable...dear topic and always fun to bounce of dbas.
All the best!
.2 of a second to .1 of a second
One experience that I can share that blew me away (as an admin not a dba) was powered by Sybase (belive v 9 at the time).
You are right no website really has that many records to see the difference - talking about 'content' based sites...but on those that are transaction & multimedia heavy I have seen difference as large as 10 sec. vs. 3 sec. of returned results. Also, have seen the very same databse lock up with alternaitve version of the same querry. "Transaction table" had about 60-70 fields and little over 3 mil. of records. nothing embeded.
Anyhow...ever since I am a beliver of taking extra time to optimise the DB.....now If I had the skills I would be set
Thanks for letting me rable...dear topic and always fun to bounce of dbas.
All the best!
-
- Joomla! Guru
- Posts: 903
- Joined: Fri Apr 07, 2006 2:36 pm
- Location: UK
- Contact:
Re: Speed Joomla Up
It's all about initial page load time. Compressing static files for transmission improves it, purely because less data needs to get to the client before it can show the page. Given how complex some CSS files get nowadays, and that the compressed version will probably be cached both on the server (for distribution to subsequent clients) and on the client (for subsequent page loads), you get a small but noticable improvement in initial page load.
Yes, it's not going to be as helpful as optimising other parts of the system, but effort/output wise, it's a couple of seconds work, and gives a noticable improvement. Optimising a poor database structure which isn't used that frequently, however, can take several hours, and give a much smaller improvement - if the queries are being cached, it doesn't matter if the initial query takes longer, since every subsequent one is much quicker.
Also, compressing CSS and HTML is easy to do, even on poor servers. It won't take the site up to dedicated server speeds, but it can make the difference between fairly slow and really slow.
Yes, it's not going to be as helpful as optimising other parts of the system, but effort/output wise, it's a couple of seconds work, and gives a noticable improvement. Optimising a poor database structure which isn't used that frequently, however, can take several hours, and give a much smaller improvement - if the queries are being cached, it doesn't matter if the initial query takes longer, since every subsequent one is much quicker.
Also, compressing CSS and HTML is easy to do, even on poor servers. It won't take the site up to dedicated server speeds, but it can make the difference between fairly slow and really slow.
FlexAdvert - the _improved_ Banner Management Suite. Find it at extensions.joomla.org under Advertising Banners
Bleurgh Joomla Extensions - http://www.bleurgh.co.uk - usage instructions, updates and so on
Performance FAQ: http://forum.joomla.org/index.php/topic,88070.0.html
Bleurgh Joomla Extensions - http://www.bleurgh.co.uk - usage instructions, updates and so on
Performance FAQ: http://forum.joomla.org/index.php/topic,88070.0.html
- trichnosis
- Joomla! Explorer
- Posts: 315
- Joined: Wed May 17, 2006 4:15 pm
Re: Speed Joomla Up
thanks guys this is very helpfull topic
Last edited by trichnosis on Fri Feb 02, 2007 2:49 pm, edited 1 time in total.
-
- Joomla! Apprentice
- Posts: 14
- Joined: Sat Aug 12, 2006 7:07 am
Re: Speed Joomla Up
I found this code in order to optimize mysql... what do you guys think?
I dont know any php so can anyone tell if it is up to par...
----------------
I dont know any php so can anyone tell if it is up to par...
----------------
-
- Joomla! Apprentice
- Posts: 14
- Joined: Sat Aug 12, 2006 7:07 am
Re: Speed Joomla Up
regarding the code above...
It is suggested that you call the code something like db_optimizer.php and put the code outside of your root directory, and run a cron job
It is suggested that you call the code something like db_optimizer.php and put the code outside of your root directory, and run a cron job
-
- Joomla! Enthusiast
- Posts: 215
- Joined: Tue Oct 04, 2005 6:06 pm
Re: Speed Joomla Up
It looks ok to me, nothing you can't do with a copy of phpmyadmin. That said I guess if its called with a cron you can do it on a regular basis, hence removing the chances of you forgetting.
-
- Joomla! Apprentice
- Posts: 14
- Joined: Sat Aug 12, 2006 7:07 am
Re: Speed Joomla Up
supposedly repairing the tables in the database can slow down the site a lot... is there any way around it? And how do you know if the tables need repairing?
Thanks
casper007
Thanks
casper007
-
- Joomla! Apprentice
- Posts: 9
- Joined: Thu Mar 02, 2006 1:46 pm
- Location: Stirling, Scotland
- Contact:
Re: Speed Joomla Up
Well to answer your question with another:
If you have the above code set to run, at say 2am, on a Cron job, and it takes less than 10 seconds to optimize/repair everything... how might this slow down your website for Mr. J. Public and his wife, who aren't nocturnal, when they visit your website?
^^
If you have the above code set to run, at say 2am, on a Cron job, and it takes less than 10 seconds to optimize/repair everything... how might this slow down your website for Mr. J. Public and his wife, who aren't nocturnal, when they visit your website?
^^
d.
-
- Joomla! Apprentice
- Posts: 14
- Joined: Sat Aug 12, 2006 7:07 am
Re: Speed Joomla Up
That was funny.Mr. J. Public and his wife, who aren't nocturnal, when they visit your website?
No, I meant that after your tables are repaired, the site is never the same anymore. I guess from what I understand it is a bit like your brand new car being in a huge wreck. Then you got it back from the body shop, it looks fine but doesn't feel like it used to... it lags here and there... alignment is always off... nobody knows why... etc...
is that true? If the table is repaired in a database, can it slow the overall performance? If thats the case, how do you spot if the table is in need of repair?
cheers
casper007
Last edited by casper007 on Fri Feb 23, 2007 8:44 am, edited 1 time in total.