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