Category pages with hundreds of products very slow

motybz · December 26, 2014, 09:45:17 AM

the site: https://www.a-avrahami.co.il/
i use:
joomla: 2.5.28
VirtueMart: 2.6.10
php: 5.3.29
i use the joomla cache plugin and JCH Optimize.
The Standard pages in my site have good speed.
but In my site Category pages (with hundreds of products and more) the page is very slow
for example in this page: https://www.a-avrahami.co.il/en/?option=com_virtuemart&view=category&virtuemart_category_id=1523
in firebug i see this :
"waiting-time:17.17s"
and when i check the debug i see this:
"Application 16.532 seconds (+15.705); 56.26 MB (+44.263) - beforeRenderModule mod_menu"
and this:
"15901 Queries Logged"
what can i do to reduce the waiting time?
thank you!

jjk · December 28, 2014, 23:03:28 PM

Looks to me like the primary issue is the image resizing you are doing on your pages, which adds a lot of work for the server. I think the site would load faster if you would use a layout which doesn't require to resize images for display. See here: http://www.dotsamazing.com/en/labs/phpmemorylimit
Also I think your site loads several extensions (plugins) which you do not actually use. Try to unpublish/uninstall unused extensions, modules and plugins.
For example I noticed a yagendoo cart module, but your supermart template has a nice cart module already.

motybz · January 01, 2015, 09:51:50 AM

Quoteimage resizing you are doing on your pages,

Can you please be more clear?
You mean to css?
You mean images of the categories or products? (Or both)
What I set wrong? I need to reduce all images manually?
I really appreciate your help! Thank you!

jjk · January 01, 2015, 20:38:22 PM

I don't know how much time the resizing of the thumbnails in your category views takes. I never experimented with that.

Here is an example from your product views: SKU: 832746, actual image size: Width = 800px Height = 571px. But this doesn't fit into your image container, so it has to be scaled down. However, it's probably difficult to find a configuration that avoids most image scaling if you want to use the zoom effect.

Code Select

div id="fancybox-content" style="border-width: 10px; width: 890px; height: 485px;">
<iframe id="fancybox-frame" frameborder="0" src="/en/חלפים-לעולם-הקפה/מכונת-קפה/אום--3-8-detail?superview=quickview&tmpl=quickview" scrolling="auto" hspace="0" name="fancybox-frame1420136794702">
<html>
<head>
<meta name="viewport" content="width=device-width; height=device-height;">
<link rel="stylesheet" href="resource://gre/res/ImageDocument.css">
<title>1349042.jpg (JPEG Image, 800 × 571 pixels) - Scaled (84%)</title>
</head>
<body>
<img class="shrinkToFit" width="679" height="485" src="https://www.a-avrahami.co.il/images/stories/virtuemart/product/1349042.jpg" alt="https://www.a-avrahami.co.il/images/stories/virtuemart/product/1349042.jpg">
</body>
</html>
</iframe>
</div>

Other suggestions:
- Category Pagination Sequence: I would use something like 16,24,32. If a customer selects 80,160 or even 400 from your dropdown list, it takes way too long to load the page into the browser.
- You may use Firebug to locate elements which add to the page loading time and then think about whether or not you really need it. For example, Firebug shows me loading font-awesome from an external source takes pretty long. Personally I don't like loading webfonts from Google, although this is popular among template designers, because they often load very slow or not at all. And do you need to load the acymailing module on every page? There also seem to be several slidehow/caroussel modules of which you probably need just one.

Perhaps compare your site with other shops using the supermart template. I know one where Firebug shows only 6 javascript request for a category view instead of your 32.

BTW- you mentioned "15901 queries logged". That's not normal. I think my own old shop shows 135. And on a test site the maximum I get is approximately 350 queries. Perhaps Joomla Debug tells you which extension is responsible for the majority of queries.

jenkinhill · January 01, 2015, 23:37:20 PM

{quote]
php: 5.3.29
[/quote]

I would also point out that rather than using an outdated PHP version, updating the server to use PHP5.4 or 5.5 will give increases in site speed.

News:

Category pages with hundreds of products very slow

motybz

jjk

motybz

jjk

jenkinhill