Website Slow - On Images

  • Posts: 149
  • Thank you received: 0
12 years 5 months ago #54056

Hi,

It seems there might be an issue with performance with the product.
We have a website with near 10,000 products and with images assigned to products.

The pages load slowly, but when I have introduced an index on the hikashop_file table the pages load ok now.

The problem now when we use sorting (Ascending Descending). The page times out and we get a "500 Internal Server Error" (This happens when the category has a large number of products). Checking website load speeds it seems that all images take a considerable amount to load (Used: tools.pingdom.com and all images, which are only some Kb of size, require a lot of time which I guess casue the connection to time out)

Can you advice what query is running exactly on Sorting filter and where I can find the exact query being build?

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 5 months ago #54128

There is only one big query for each products listing.
The more you add filters and the bigger the query will be.
The query pieces are scattered around the field.php file of the administrator/com_hikashop/classes folder and the components/com_hikashop/views/product/view.html.php file.


Regarding the images, it could be that HikaShop is not able to generate the thumbnails for your products (for example because of access right issues on the media/com_hikashop/upload folder) and tries to generate them each time on each pages.

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

  • Posts: 149
  • Thank you received: 0
12 years 5 months ago #54402

Hi Nikolas,

When you are saying there might be access right issue on the images folder what do you mean exactly. What should we check?
The folders for the thumbnails exist with all the images as well. In addition there are the below folders whithin "media/com_hikashop/upload" and with the thumbnail pictures pre-created
thumbnail_100x100
thumbnail_132x132
thumbnail_229x229
thumbnail_230x230
thumbnail_290x290


How can we find out whether there is an access issue as you are saying. The folder permissions are ok and the owner is the website user

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 5 months ago #54445

From what you're saying, the system was able to generate all the thumbnails, so it doesn't come from that.

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

  • Posts: 149
  • Thank you received: 0
12 years 4 months ago #54679

Hi nicolas,

What are the next steps to identify what is causing this issue. Users cannot browse the website to categories with a big amount of products.
Sorting on Price and Filtering against price produces an Internal Server error due to slow response.

Please advice

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #54816

Hi,

We can have a look at your website to see if everything is working properly regarding the images. Could you provide a ftp account, a back end access and a link to the page where you have the problem via our contact form ?
www.hikashop.com/en/contact-us.html

Regarding the sorting on prices, it's an extensive processing, so if you have lots of products it's normal that it takes lots of resources. That's because the prices need to be calculated dynamically based on currency rates, fees, discounts, variants, etc. So the SQL query becomes really heavy. The only solution would be to precalculate the prices automatically with a cron so that the results could be used directly for sorting, without having to recalculate everything. That's possible, but not something I can fix for you in a few hours, paid or not. That would require proper development and is not a small task.

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #55474

Hi,

I tried to activate the debug mode of your joomla configuration but that doesn't work. It produce a 500 error on the front end.
Do you know why ?

It would be great to be able to activate it in order to see where the bottleneck is, if any.

Also, the FTP account you provided does not work.

Finally, I turned off the "thumbnails" option of the Files tab of the configuration so that no images are displayed for the products on your products listing and the page processing time is exactly the same.
Which makes me believe even more that it doesn't come from that but something else on your website.
The page takes about 2 seconds to process. What takes time for the page to be fully loaded is the downloading of the images. Are you talking about the downloading or the processing of the page ? Because if it's the downloading, there is not much we can do. It's just that your server is slow to send the data. You would have to have a hosting plan with more resources in order to improve the speed at which apache is able to send the images to the browser...

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

  • Posts: 149
  • Thank you received: 0
12 years 4 months ago #55491

Hi Nicolas,

Can you tell us what debug mode does exactly so we can trace what could be wrong

in addition, we just emailed you new login details for ftp

The problem is that the website fails with error 500 internal error (we were suspecting something with the images, as the scanning showed from other sources) but it seems its not the images as you are saying.

We would like to examine the queries and see whether this is what is causing the issues

Try the FTP access and let us know if you need anything else

Thanks again for the help

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #55493

Turning on the "debug mode" option of the configuration of joomla displays the queries used on each page, at the bottom, among other information.
That's exactly why I wanted to use it to see what could be the problem.

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

  • Posts: 149
  • Thank you received: 0
12 years 4 months ago #55511

Hi,

Where can we enable it from?

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

  • Posts: 82820
  • Thank you received: 13368
  • MODERATOR
12 years 4 months ago #55513

In the configuration of Joomla.

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

Time to create page: 0.069 seconds
Powered by Kunena Forum