Speed Joomla Up

deizel · **Posted:** Mon Feb 26, 2007 10:03 am

The script you pasted tries to run the OPTIMIZE command. Only if it fails, will it run the REPAIR command, and then a following OPTIMIZE command.

After a long, hard day of fetching and editing tables, MySQL can become overburdened and create overhead. This can be almost directly compared to how defragmentation occurs on a hard drive. For example, something needs to be replaced in one location but there is not enough space so part of it goes here and part goes there; discontinuous. Over time, overhead for very active tables in your database can reach high levels.

Optimizing a database is akin to defragmenting your harddisk and simply rebuilds the table and frees up space, while Repair repairs a possibly corrupted table.

To be honest though. I don't think you would see much benefit, if any, in running this script on a small site. Think: How often do you defragment your computer's harddisk, and how big is it/how much activity does it see compared to your website? In saying that, I'm sure this would be absolutely essential in making sure a large site, like this one, doesn't grind to a halt over time.

Edit: Oh, and to answer your question more directly, I don't think this would cause degraded performance of your MySQL database. Worst case scenario, you may lose data when a corrupt table gets repaired, so, naturally, one may want to have regular backups of the site database.

tjrac · **Joined:** Sat Aug 27, 2005 3:17 pm **Posts:** 21

Hey Folks,

Check this out
http://rakaz.nl/item/make_your_pages_lo ... _css_files

Seems to work pretty well.

mpettitt · **Posted:** Mon Mar 05, 2007 9:58 am

In general, Joomla tends to only use relatively few CSS files, unless you're doing some strange things with the template, but compressing them can help dramatically - I run them all through a 1 line PHP script, which gzips on request, and is cached, so once it has loaded once, it serves the compressed version, unless the browser can't handle compressed CSS (some very old ones - not a common thing!) in which case it gets the plain version.
Combining the JS files sounds interesting, although I'm not sure how well it would work with AJAX scripts.

lonely_mizo · **Joined:** Sun Mar 16, 2008 2:14 am **Posts:** 125

Quote:

Take a look here and check for your websites performance:
http://www.websiteoptimization.com/services/analyze/
This page gives you a summary about your websites objects and has proposals how to improve it.

The only site I could see with a perfect output is yahoo.com, they have lots of img's or icons on the front page, even more than most sites but how do they managed to do it so?, we've managed to minimize most of non-joomla (non-cms) sites we've created but I can't think of much solutions in my joomla site/s as it has to depend on lots of extensions to make it look good...and i really dont see the differences with those accelerator extensions does... may be am missing something.

Many thanks to heckwar and deanmartin for being very very informative.

hanlylim · **Joined:** Sun Feb 24, 2008 12:07 am **Posts:** 18

Hi,

Does anyone has the answer regarding making Joomla site to load like Yahoo.com ?
I would like to know how that is done cause my site is about 260 Kbs (compressed, css gzipped, images optimzed) but still doesn't load like Yahoo.com which is about 6-7 Kbs !

Cheers.

Hanly

Aly · **Joined:** Mon Aug 22, 2005 8:56 pm **Posts:** 211

My site is not that slow, but the ADMIN is ridiculously slow. In fact, I cannot get to the menus (only visible links like preview/logout) without having to log out and back in again.

I have disabled gzip, SEF
Turned on web services
and am using a new, fresh install of the latest 1.5 version

Hosting for this client is at: jumpline.com

I'm going NUTS! I can't edit or add content at this rate without logging out and in between every article. I just logged in and clicked Category Manager. Firefox is spinning and spinning, loading and loading - but I can't fathom what is loading.

I created a new Category but now I cannot get to the Content menu to add an article.

EDIT: this problem is not happening when I use IE 7. It is still slow on Firefox to the point of never completely loading on most pages.

sivalik · **Joined:** Fri Jul 11, 2008 12:22 pm **Posts:** 3

hanlylim wrote:

Hi,

Does anyone has the answer regarding making Joomla site to load like Yahoo.com ?
I would like to know how that is done cause my site is about 260 Kbs (compressed, css gzipped, images optimzed) but still doesn't load like Yahoo.com which is about 6-7 Kbs !

Cheers.

Hanly

This what Yahoo has to say:
http://developer.yahoo.com/performance/rules.html

doktorrr · **Joined:** Wed Feb 07, 2007 10:09 pm **Posts:** 90

I recently have problem with speed site and I 'm remove some css code in templates files. Since than,my site is improve speed.

guruananthe · **Joined:** Wed Feb 25, 2009 10:37 am **Posts:** 43

Page Load depends on the size of the images , reduce the images size and load with CSS.

drarvindc · **Posted:** Wed Mar 11, 2009 3:37 pm

Just finished writing article on speeding up tips for joomla.

[removed self promotion]

Choice of template is half the game, in speeding up Joomla. Interesting to note that each image is equivalent to 1 HTTP request. Less the image faster the joomla is. CSS code clean up, removal of extra stuff from CSS does help in decreasing HTTP requests.

One can easily take away atleast 20-30 HTTP requests away from any Joomla template without much effect on the template functionality.

Its sad to see, users just see the thumbnails size visually, one should check the property of thumbnail and should optimize them, there is always scope to compress a thumbnail. At times, upto 10 KB per thumbnail can be saved and thats very beneficial if you have a good traffic site.

For example, if you save 30 HTTP requests and you have 500 visitors per day. You just saved 30x500 = 15,000 HTTP requests a day. So even if you remove 1 image from your main page you save 1 HTTP request.

Have tried to explain it properly, with screenshots from WSO.

gaurav_joomla · **Joined:** Thu Feb 26, 2009 7:10 am **Posts:** 2

booger wrote:

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:

Code:

<?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'); ?>

Then change your template to reflect the name as stated before:

Code:

<link rel="stylesheet" href="/templates/<name-of-template>/css/template_css.php" />

That way you can still edit your css file through the admin panel.

What about if we have the include some special css like this??:
<link rel="stylesheet" href="templates/beez/css/template.css" type="text/css" />
<link rel="stylesheet" href="templates/beez/css/position.css" type="text/css" media="screen,projection" />
<link rel="stylesheet" href="templates/beez/css/layout.css" type="text/css" media="screen,projection" />
<link rel="stylesheet" href="templates/beez/css/print.css" type="text/css" media="Print" />
NOTICE: the media

when we use just include then the special characteristic of the css is compromised.. any alternative or suggestion? and if i first want to do a small test then how do i come to notice that the zipping has occurred and the page is lighter. how do u weigh pages. is there any tool available? pls help me as i m a bit novice :|

gaurav_joomla · **Joined:** Thu Feb 26, 2009 7:10 am **Posts:** 2

hi
can you suggest how to use these types of css links having special characteristics of media rendering. eg. <link rel="stylesheet" href="templates/beez/css/position.css" type="text/css" media="screen,projection" />
NOTE: the media in the link
I have tried it and the include in php doesnt support this property. so how to go about it ??

please suggest.
Much Thanks
-Gaurav

jamesmeijer1234 · **Joined:** Fri May 15, 2009 6:43 pm **Posts:** 36

thanks for the great tips, they will really come in handy soon. ( currently making and testing my site.

smithe · **Joined:** Sun Apr 12, 2009 2:53 am **Posts:** 2

Question from a newb.

Do disabled mods slow page load?

cipek1981 · **Joined:** Sat Dec 20, 2008 9:01 am **Posts:** 20

Great tips. I will try.

Joomla! Discussion Forums

Forum rules

Speed Joomla Up

Quick reply

Who is online