Performance when MANY tables in InnoDB database???

[Tore]

Hi.

InnoDB tables only.

Today I have all my customers in 4 tables.
All of my customers today can update, insert, delete records any time in these tables. Each of my customers have many visitors....
This makes use of query-cache inefficient.

I'm considering putting each of my customers in their own tables.
So when I get new customer I just want to create 4 new tables for this customer.

My hope was that by having 4 tables for each of my customers then the query-cache would be very efficient.

But I'll guess there is some (maybe huge) drawback using many tables in the same database... I'm talking about 400 to 1000 tables.

1.
How well does InnoDB works with many tables in same database?

2.
Anybody with experience or links to some information about this, and some tip on what I have to do to make database run fast even if many tables?

3.
Memory usage, threads, server-variables values ?????

Have searched the web and looked at MySql homepage without any luck.


MySql, Table-Structure, QueryCache, Webserver, PHP, Dynamic generation, Linux.