Slow jDownloads frontend after upgrade from Joomla 3 to 4

[SoundHunter]

Hello jDownloads team,

Yesterday we have upgraded our website from the latest Joomla 3 version to Joomla 4.
We follow the upgrade guide from jDownloads 3 to 4.
This went smooth and after the upgrade all the downloads are still there and are working correct.
The only problem is the load time, on Joomla 3 the category page (with 6 categories) was quickly loading in a blink. On Joomla 4 the page has a load time of about 4 seconds.
When we click on a category with about 1665 mp3 files it was on Joomla 3 slightly slower than the categories section. On Joomla 4 it takes around 12 seconds to load.

I already did research but can't find any error like PHP errors for example.
The website runs on the same hosting packets as yesterday before the upgrade.

Setup information:
  - Joomla Version: 4.4.4.
  - Installed jDownloads Version (see jDownloads control page at the footer): 4.0.42
  - PHP Version: 8.2.18
  - Use you the standard backend template? Yes
  - It is a new Joomla 4 installation? No

Hopefully we can find the underlaying reason about this problem.

Thank you!

Kind Regards,

SoundHunter

[Arno]

Hi SoundHunter,
I have received the login data from Colin and have had a look at it.

I couldn't find any unusual jDownloads settings that could be the cause of your problem, but what I did notice is the following: - loading times are regularly just over 5 seconds. This seems a bit long, but could be due to the server settings. But it could also be due to the number of customers who are hosted on this server and how much their websites are frequented by visitors.

You can see for yourself that a large number of downloads and categories is generally not a problem for jDownloads here: https://jd44.jdownloads.org/index.php/downloads

This test installation is hosted on a server with a maximum of 30 other websites. However, it only contains the Joomla 4 basic installation and jDownloads with 978 categories and 3523 Downloads.

I would advise you to contact your hoster and find out to what extent it is possible to switch to a better or less busy server.

[SoundHunter]

Hi Arno,

Thank you for looking into this!
I just sended you a PM with more information.

[musicasampler]

Hi Arno, I see that your test site is fast enough. I have my site hosted on a VPS;
CPU cores 8, Memory 32 GB, Bandwidth 33 TB, Disk space,400 GB
and it is very slow with a delay of up to 15 seconds. In fact, I have more than 40,000 MIDI files that are not very large. I really don't know what's going on. the delay is only in jdownloads, thank you

[ColinM]

Hi,
To me this looks like a VPS challenge.  It is perhaps trying to load all the Downloads
 
Could you advise how many jD Categories you have and what is the typical number of Downloads in a Category.
Colin

[musicasampler]

musicasampler.com - It has 90 categories, some have 2000 or more and most have between 400. I don't think that's the problem, maybe it's the VPS or the database queries.

[ColinM]

Hi
I am not familiar with VPS- will ask Arno to look
Colin

[musicasampler]

I repeat that it should not be a VPS problem. It seems to me that JD is slowing down because of so many files. On this page I have 41,000 files. I have another page on a shared hosting that only has 6,000 files and is faster. Something is slowing down JD when there are too many files.

And the truth is that Joomla JD is the only component that works very well to download and share music files among thousands of users (MUSICASAMPLER.COM)

[Arno]

Hi,
I will publish an update in the next few days. It will also include an improvement in the use of the DB, which will also improve the speed.