Data base optimizer

[musicasampler]

hi ColinM. Could you help me optimize my website's database? Maybe this will help me improve my site speed.

[ColinM]

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

[musicasampler]

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.

[ColinM]

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

[musicasampler]

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.

[ColinM]

Hi
Have you ever considered the jD External exterrnal downloads
Maybe just for the larger music files

[musicasampler]

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.