VM 2.0.12f VERY slow on category view

[SightVision]

Hello everyone,

I've build a website with a webshop, using Joomla 2.5.7 and VM 2.0.12f
The website itself has enough speed, but whenever I choose een category of products in the webshop, the loading page for a category is sometimes going up to more then 20 seconds!

I've read multiple threads about caching, JOTcache, and a thread about to much SQL queries for loading a category page, but al these items doesn't solve my problem.
When I turn caching on, Joomla based, or JOTcache, the whole webshop is messed up, modules doesn't work anymore etc.

Is it possible that the problem still lies at the amount of SQL queries, needed for a category view? I'm a little desperate here.

The url is http://www.cinza.nl/index.php?option=com_content&view=article&id=21&Itemid=125.

Please help!
Thank you

SightVision

[PRO]

sightvision,

You can use JCH optimize   
http://extensions.joomla.org/extensions/core-enhancements/performance/site-performance/12088

USE IT FOR CSS files ONLY


That will help a lot

ALSO:

you can set an "expires header" with htaccess

<FilesMatch "\.(ico|pdf|flv|jpg|jpeg|png|gif|js|css|swf)$">
Header set Expires "Thu, 15 Apr 2013 20:00:00 GMT"
</FilesMatch>

BEWARE WITH MESSING WITH HTACESSS, the wrong syntax, or opening and saving it in the wrong format will break the site.
SO, test it locally, or on a test domain first.

Those 2 should help quite a bit

[Milbo]

Interesting hints Pro,

Do you use a lot of customfields? In the new version 2.1, this is already enhanced. I also enhanced the router using a lot more instant ram caches.

[SightVision]

Pro,

thanks for your tips!! I had already installed JCH, but I used it also for js. Now I've used it only for css, and really, it makes a difference, but still the loading time for the category page is unacceptable (min. 14 sec.)
I've also added the code in my .htacces, but I noticed do difference in speed. What I did notice, that the speed of the whole website is really oke, except for the category view. When I use the joomla bugreport, I see that there are round 600!!! SQL queries used to load this page.
I guess this is the real problem that causes the slow loading time.

Milbo,
I indeed use customfields, but that are only 6 fields. They are used for the 3 party extension Cherry Picker (filtering products, grey bar). I guess 6 custom fields aren't that much different in the amount for queries?

I've really very little experience with SQL, so I really have no clue how to fix this

I hope there is a solution for this!!

Thank you,
Regards,
SightVision

[PRO]

loading this many js files will NEVER be fast
AND, you are loading 2 different jQuery files

jquery-1.5.2.min.js
jquery.easing.1.3.js
jquery.animate-colors-min.js
jquery.skitter.min.js
mootools-core.js
core.js
caption.js
mootools-more.js
dropline-helper.js
djmenu.js
dojo.xd.js
uacss.xd.js
easing.js
dojox_widget_fisheyelist.js
mod_ajax_dockcart.js
jquery.min.js
jquery.noConflict.js
vmsite.js
facebox.js
vmprices.js