Posted February 3, 20223 yr We are using Downloads Application in Version 4.6.10 (106154) For a while now, the Downloads Page is loading extremely slowly, with Time to First Byte constantly above 10 or 15 seconds. Most Category Pages, and Downloading single Files is not experiencing the problem, neither is the Forum Application. But the Downloads Overview Page (first page of Application), which displays Newest Downloads, Most Downloaded etc. is taking extremely long. We have updated everything to the most recent version. We have disabled all customisations. Nothing worked. There are no errors or warnings in the logs. The RAM and Filesystem have plenty of resources free. Neither Filesystem or MySQL Data Storage seem to make any difference. Any help in resolving this problem would be greatly appreciated.
February 3, 20223 yr Author Seems there is a problem with categories with many files. We have a category with 4 subcategories and 1200 files. If we "disable" this category everything is fast, if we enable it, it's getting slow.
February 3, 20223 yr Community Expert If you could please have your hosting provider enable slow queries on your MySQL server for queries greater than 10 seconds and we can take a look at that log for further details.
February 10, 20223 yr Author Thank you. Please find attached the Slow Query Log you requested. 10-Feb-2022_13_59_44_usr_p189125_2.log
February 10, 20223 yr Community Expert I have flagged this for a developer to take a look at. In the most part however, you will find these tend to be hosting related problems. I Would urge you to also continue working with your host to improve the performance of your MySQL instance. While I know you have stated above you have plenty of resources free, that would not necessarily mean its performing optimally. In fact, this can actually be to the contrary. Free memory for example is memory not being utilised. While you wouldnt want it maxed out constantly, you also dont want under utilised resources. Which is where optimising applications such as MySQL for performance comes in.
February 14, 20223 yr Community Expert 31 minutes ago, Matthias Messerer said: Any updates from your developer? Please be advised that advanced support is only available Monday - Friday. They will reply here as soon as they are available to do so.
February 14, 20223 yr Community Expert Solution I believe this issue is related to the amount of categories you have. I have identified where the problem is, and have submitted a fix for a future version.
February 15, 20223 yr Author Great news. We are looking forward to the update that improves the performance with many categories.
March 8, 20223 yr Community Expert A new version (4.6.11) has now been released which resolves this issue. Please upgrade to the latest release in order to get this fix.
