Heavy product load

  • Posts: 2
  • Thank you received: 0
9 years 4 months ago #238550

-- url of the page with the problem -- : www.stopshop.bg/
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.6.17

Hello,
We use Hikashop Business 2.6.1
We have more than 30 000 products, divided into 180 categories. The products have a wide range of specifications as a result of this the table hikashop_product has more than 1,000 columns. References to the table are very slow and heavy, which leads to an overall slowing of the website.
How can we optimize the loading of product data in this case?

Please Log in or Create an account to join the conversation.

  • Posts: 84310
  • Thank you received: 13701
  • MODERATOR
9 years 4 months ago #238556

Hi,

Besides reducing the number of columns, or increasing the resources of the server, the only option left is to use caching to speed up the pages once they get displayed once.
If the specifications are not used for filtering or product comparison, I guess that you could remove them and add them directly in the description, but I suppose that's not the case.

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum