MYSQL table performance question..?

[Kaz]

In a virtual hosting environment, often the host will only give the clients access to a single mysql database (and many tables).

My question is if I have a massive table... say millions of entries and a small simple table in the same DATABASE, will the small simple tables performance be effected at all by being in the same database with the massive table?

Thanks in advance 🙂

[eoghain]

Simply: No.

As long are you are only doing an operation on the small table (no joins with the big one) then there will be no impact.