Website very slow

-- url of the page with the problem -- : www.dragongrill.dk
-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3.
-- PHP version -- : 5.4.
-- Browser(s) name and version -- : Google Chrome

Hi Hika Support

My website is pretty slow compared to another webshop I made with Hikashop. I saw this thread www.hikashop.com/forum/install-update/86...formance.html#141512

but I don't fully understand what I can do to make my website/webshop faster?

Best regards

Carsten

Hi,

I guess that the problem is link with the modules you put.
This page load is good : www.dragongrill.dk/index.php?option=com_...egory&id=15&Itemid=0
The page load is not good : www.dragongrill.dk/index.php?option=com_...ory&id=15&Itemid=101

Regards,

HI Jerome

In the first link - of course it is faster - it doesn't load all the products...

What can I do to make the load speed fast even with the modules on?

Best regards

Carsten

Hi,

Well, you're loading tens of modules there, it's normal that it's slow.

Just the HTML of the page is 2MB because of that instead of 75K.
If you're on an ADSL link at 512K, you'll need 1 second to download the page without the modules at full speed of your connection, and 27 seconds for the page with the modules, just because the HTML of the page is big as there is too much data to transfer.
And you can't do much about that.

Regarding the speed of the generation of the page, it takes 8 seconds versus 0.7 seconds. If you want to speed that, it's possible by caching the modules processing. As HikaShop needs to display dynamic content on the page, you can have a full cache on your website, but you can activate the cache only for some modules, like the ones at the top for the listings of products.
If you want to toggle caching on/off with individual modules, set the global cache type of the Joomla configuration to Conservative and then use the module's cache type option (when you edit a module via the joomla modules manager) to enable / disable caching

Hi Nicholas

I made an example page with all the products on one page, without any modules. I can't say that this made the loading faster.

dragongrill.dk/index.php?option=com_hika...t=listing&Itemid=461

Best regards

Carsten

Hi,

I takes about 9s to display this page, you have 510 products to display at a time.
The performances can be different depending on the server used, so in my point of view this page load is not really good, but not so bad.

For this kind of listings, it's better to have a pagination..

Regarding the other links, it really seems to be due to the modules.

Hi Xavier

Thank you for your response. It so happens that my client wants all the products listed on the same page, as it is a fast food restaurant.

Is it possible to "tune" the Mysql database queries and how?

I came across this thread: www.hikashop.com/forum/install-update/86...formance.html#141512

Best regards

Carsten

Hi,

Rather than tuning MySQL, which won't help, you should rather use caching on your website. The caching will avoid loading the data from the database altogether for the page and thus you'll get a big boost in speed. That's why I recommended it in my previous message.

The thread that you found was about displaying a normal listing of 20 products while having millions of products in the database, which is an entirely different problem from yours. In your case, the problem is not the queries which are slow because of too much data to search the products to load the data, but the fact that the data which is loaded is itself too big to handle with enough speed.
And anyway, the improvements of the database from that thread have already been added in HikaShop.

Hi Nicholas,

thank you for your help this far. I don't think I can use the cache for a couple of reasons.

The Shopping cart is not dynamic
The fetch of the "add to cart" code, which is included in the modules text, will be broken if cache is on.

Best regards

Carsten

Hi,

If you want to speed that, it's possible by caching the modules processing.

Like it was written before in this thread, you can just use an extension to cache the modules, not the rest of the page.

Regards,