Performance of webshop is slow.

  • Posts: 24
  • Thank you received: 1
  • Hikamarket Frontedition Hikaserial Standard Hikashop Business
9 years 6 months ago #233130

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.4.45
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : None

I have 6600 categories and 13000 products in my webshop. Both are imported into Hikashop by a self written component.
There are only 10 top level categories and the categories are 5 levels deep.
Entering the webshop only displays the toplevel and there after by choosing the required category the shop displays only the next level. Entering the shop as well as displaying products at the lowest category level takes more than 30 seconds.

Products only have 1 price and 1 image (if available).

I cannot get a clue where to start improving the performance.

For the moment debug is set to yes and error reporting is set to max level.

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

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #233141

Hi,

If you look at the debug data, you can first see this:
take.ms/btxtf
All processing time of the page is taken by the VKV shop module.
That module is a 2 levels category listing module.
So two possible solutions without getting deeper into searching:
- remove the module, and instead create a menu with one menu item for each category and use a menu item module to display that menu's items instead. The look would be the same, it would be a bit more management, but the solution isn't complex.
- try using something like the skyline accordion for HikaShop:
extensions.joomla.org/extension/skyline-...cordion-for-hikashop
It supports even more levels of display and as the data is loaded dynamically in Ajax, it shouldn't take time to display.

Looking deeper into it, you can see that the problem happens after the query 30:
take.ms/wdcAG
And that query is quite troublesome as it loads all the categories of each category of the listing, regardless of the level.
The comes from the "sub element filter" setting of the module, which is apparently set to "all sub elements".
Change it to "direct sub elements" and that should help avoid the problem.

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

  • Posts: 24
  • Thank you received: 1
  • Hikamarket Frontedition Hikaserial Standard Hikashop Business
9 years 6 months ago #233208

Nicolas,

Thanks for the quick response. I also looked into the timings, but apparently missed it. The settings in the sub-elements filter were already set to 'Direct sub elements'

Disabling the module helped a lot!. Changing the show children to NoChild also improved the performance. I can live with only one level in the module; still have to improve the css for better display.

The settings of the module are now like take.ms/OqbGn

On my local desktop this works fine, but on the unix server the breadcrumbs are not shown correctly. Any idea why?

By the way, the settings on the admin site do not show the images correctly in unix due to the use of capitals in the file name (for example ../media/com_hikashop/images/icons/icon-24-list-selected.png, the filename has a capital 'L' in the name)

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

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #233216

Hi,

I see that the breadcrumb is always the same. This seems that you have caching activated on it. The breadcrumbs module shouldn't be cached or it won't update itself on each page display. So deactivate the caching for it and it should help.

Regarding the images, I'm not sure what you mean. We do you use the backend of HikaShop on unix systems and didn't notice any image issue. Could you be more precise as to where you have that problem ? Maybe provide a screenshot of the problem ?

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

  • Posts: 24
  • Thank you received: 1
  • Hikamarket Frontedition Hikaserial Standard Hikashop Business
9 years 6 months ago #233326

Nicolas,

Thanks again; the caching is disabled for the breadcrumbs and is working as expected. I did not realize that it can be changed per module.

Concerning the images. Here you can find a screenshot of the backend take.ms/B33z6 .

All my icon-24*.png images have a capital in the filename.

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

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #233328

Hi,

Here is a screenshot of the images in the install package of HikaShop:
take.ms/YjedD
As you can see, there are no uppercase in them.
So it must be something on your website or web server changing that.

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

  • Posts: 24
  • Thank you received: 1
  • Hikamarket Frontedition Hikaserial Standard Hikashop Business
9 years 6 months ago #233458

Nicolas,

I looked into the original zip install 2.6.1 essential; no capitals were seen. However in the install zip of version 2.6.0 these files are present. See my screen shot. take.ms/ZAQ2s

Concerning the performance, this issue is solved; thanks again for this.

regards.

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

  • Posts: 84307
  • Thank you received: 13701
  • MODERATOR
9 years 6 months ago #233465

Hi,

Ah I see. You had installed the 2.6.0, and when the 2.6.1 was installed the Joomla installer didn't add the files with the correct case because of a bug in the way it checks the file names when replacing them.
In such case, you can delete the whole folder of the icons before reinstalling the 2.6.1 and it will add the images with the correct case.

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

  • Posts: 24
  • Thank you received: 1
  • Hikamarket Frontedition Hikaserial Standard Hikashop Business
9 years 6 months ago #233523

Nicolas,

I renamed the files manually.

You can close this topic.

Regards.

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

Time to create page: 0.068 seconds
Powered by Kunena Forum