[RESOLVED] Use seperate DB for stats for faster website?

Yari

Hi,

I am on a shared hosting and have unlimited mysql databases at my disposal. One of my CMS websites has roughly 1,000 unique visitors a day, I wondered if I should setup my stats program on a separate database for a faster website?

This is just theoretical as the site is working fine, but would it be faster to have the stats on a separate DB than my websites CMS (which also uses MySQL)?

Thanks

MarkR

If you're using a standard MySQL installation, there is absolutely no performance difference between tables in a different database.

The databases are simply different directories in the filesystem where it stores its files.

NOW, there are SOME cases where this is not true - for example, if one of your databases is kept on a different disc with different performance / contention issues. Talk to your DBA about that if you're sufficiently worried.

Mark

dougal85

I'd suggest the differences would be small enough to not be noticed, however if you are having performance issues then it would be something worth trying.

Otherwise;

if (!$broken){
dontfix();
}

Yari

Yes, I see.

Makes sense, and as I am not having any trouble yet, I will leave it. But good to know that if needed, I can set them up on different discs / servers.

Excellent answer as always, I love this forum!

Thanks for your time,

Yari