Text only | Text with Images

jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => General => Topic started by: musicasampler on 23.08.2025 04:51:03

Title: Data base optimizer
Post by: musicasampler on 23.08.2025 04:51:03
hi ColinM. Could you help me optimize my website's database? Maybe this will help me improve my site speed.
Title: Re: Data base optimizer
Post by: ColinM on 23.08.2025 21:28:23
Hi
Yes I will look.  Will need Admin login plus access to your phpMyAdmin etc.  Will send you a Private Message as these are secure
Colin
Title: Re: Data base optimizer
Post by: musicasampler on 24.08.2025 20:02:51
Hi Colim. I'd just like you to tell me what day and time you could check the database update and optimization. It's just to disable the site and I can make a backup before you access the hosting (I use webuzo). Musicasampler.com has a lot of traffic and almost 80,000 files in jdownload.
Title: Re: Data base optimizer
Post by: ColinM on 27.08.2025 10:56:16
Hi
I have looked at the site but I not familiar with this type of server.  As I understand it your concern is the response time for a Download. My suspicion is this is not a database problem but the amount of storage space for the downloadable files. That is I think that the sorage space might be 'paged' or similar, so the system has to load the relevant 'block of data'.  This would get worse if a user is allowed to download more than one Download at the same time.

Suggest you investigate that directly with your hosting service
Best wishes
Colin
Title: Re: Data base optimizer
Post by: musicasampler on 28.08.2025 03:09:35
Okay, I'll see what I can do, but the truth is, I've set this website to browse on different servers and it's always the same problem. The current server I have hosting the website is a 200 GB VPS and it only takes up 21 GB.
Title: Re:cron and special char
Post by: ColinM on 28.08.2025 10:42:33
Hi
Have you ever considered the jD External exterrnal downloads
Maybe just for the larger music files
Title: Re: Data base optimizer
Post by: musicasampler on 28.08.2025 10:57:02
I never considered it, because if you notice, my website is only for MIDI files, each of which weighs less than 1 mg. If they were MP3 files, I would definitely use JD external. I suspect that JDownload starts to have speed issues starting at about 30,000 files. I created a LOCAL version of musicasampler.com with only 20,000 files, and the downloads move quickly. I think ARNO should consider this situation, since I believe I'm one of the few who uses JD with many files. I hope this gets resolved. Thanks, Colin.

Maybe if you manage to make a plugin to move the entire download folder for Amazon 3 or something similar it could improve the system loading somewhat.
Text only | Text with Images