[Skip to main content](#vessel-content) # Website Slow - On Images ## - **[webarts](/forum/user/144-webarts "View webarts's Profile")** - [![webarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/144-webarts "View webarts's Profile") Topic Author - [ Offline](/forum/user/144-webarts) Less More - Posts: 149 - Thank you received: 0 - - [](http://www.webarts.com.cy) - 14 years 4 months ago [\#54056](#54056) by [webarts](/forum/user/144-webarts "View webarts's Profile") *[Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#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?")* was created by *[webarts](/forum/user/144-webarts "View webarts's Profile")* 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](http://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 14 years 4 months ago [\#54128](#54128) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#54128 "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?")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[webarts](/forum/user/144-webarts "View webarts's Profile")** - [![webarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/144-webarts "View webarts's Profile") Topic Author - [ Offline](/forum/user/144-webarts) Less More - Posts: 149 - Thank you received: 0 - - [](http://www.webarts.com.cy) - 14 years 4 months ago [\#54402](#54402) by [webarts](/forum/user/144-webarts "View webarts's Profile") Replied by *[webarts](/forum/user/144-webarts "View webarts's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#54402 "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?")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 14 years 4 months ago [\#54445](#54445) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#54445 "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?")* From what you're saying, the system was able to generate all the thumbnails, so it doesn't come from that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[webarts](/forum/user/144-webarts "View webarts's Profile")** - [![webarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/144-webarts "View webarts's Profile") Topic Author - [ Offline](/forum/user/144-webarts) Less More - Posts: 149 - Thank you received: 0 - - [](http://www.webarts.com.cy) - 14 years 4 months ago [\#54679](#54679) by [webarts](/forum/user/144-webarts "View webarts's Profile") Replied by *[webarts](/forum/user/144-webarts "View webarts's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#54679 "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?")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 14 years 4 months ago [\#54816](#54816) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#54816 "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?")* 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](http://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 14 years 4 months ago [\#55474](#55474) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#55474 "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?")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[webarts](/forum/user/144-webarts "View webarts's Profile")** - [![webarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/144-webarts "View webarts's Profile") Topic Author - [ Offline](/forum/user/144-webarts) Less More - Posts: 149 - Thank you received: 0 - - [](http://www.webarts.com.cy) - 14 years 4 months ago [\#55491](#55491) by [webarts](/forum/user/144-webarts "View webarts's Profile") Replied by *[webarts](/forum/user/144-webarts "View webarts's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#55491 "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?")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 14 years 4 months ago [\#55493](#55493) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#55493 "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?")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[webarts](/forum/user/144-webarts "View webarts's Profile")** - [![webarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/144-webarts "View webarts's Profile") Topic Author - [ Offline](/forum/user/144-webarts) Less More - Posts: 149 - Thank you received: 0 - - [](http://www.webarts.com.cy) - 14 years 4 months ago [\#55511](#55511) by [webarts](/forum/user/144-webarts "View webarts's Profile") Replied by *[webarts](/forum/user/144-webarts "View webarts's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#55511 "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?")* Hi, Where can we enable it from? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 14 years 4 months ago [\#55513](#55513) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Website Slow - On Images](/forum/4-how-to/54056-website-slow-on-images#55513 "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?")* In the configuration of Joomla. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU0MDU2LXdlYnNpdGUtc2xvdy1vbi1pbWFnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.093 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)