Website very slow

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,

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,

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,

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