Matthias Messerer Posted February 3, 2022 Share Posted February 3, 2022 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. Link to comment Share on other sites More sharing options...
Matthias Messerer Posted February 3, 2022 Author Share Posted February 3, 2022 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. Link to comment Share on other sites More sharing options...
Jim M Posted February 3, 2022 Share Posted February 3, 2022 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. Link to comment Share on other sites More sharing options...
Matthias Messerer Posted February 10, 2022 Author Share Posted February 10, 2022 Thank you. Please find attached the Slow Query Log you requested. 10-Feb-2022_13_59_44_usr_p189125_2.log Link to comment Share on other sites More sharing options...
Marc Posted February 10, 2022 Share Posted February 10, 2022 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. Link to comment Share on other sites More sharing options...
Matthias Messerer Posted February 14, 2022 Author Share Posted February 14, 2022 Any updates from your developer? Link to comment Share on other sites More sharing options...
Jim M Posted February 14, 2022 Share Posted February 14, 2022 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. Link to comment Share on other sites More sharing options...
Solution Ryan Ashbrook Posted February 14, 2022 Solution Share Posted February 14, 2022 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. Matthias Messerer and IveLeft... 2 Link to comment Share on other sites More sharing options...
Matthias Messerer Posted February 15, 2022 Author Share Posted February 15, 2022 Great news. We are looking forward to the update that improves the performance with many categories. Link to comment Share on other sites More sharing options...
Marc Posted March 8, 2022 Share Posted March 8, 2022 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. Link to comment Share on other sites More sharing options...
Recommended Posts