> But what about INNODB? And are there
> table engine-independent implementation details which might cause
> performance problems for a database with many tables?
This thread got me wondering how many file-handles are open for INNODB tables
since it is only one large file on the file system. A q
Usually the performance hit is coming from the OS/file system.
Tracking 100,000 file handles along with all the other stuff the OS
is doing will slow any system down. If you have 1,000 tables, you may
want to rethink you data model. If you truly need that many tables,
you're better off spli
2005/9/1, Chris Cutler <[EMAIL PROTECTED]>:
> Hello,
>
> My apologies for repeating a question asked earlier[1] but the
> question and the answer were a little vague:
>
> Does the number of tables in a database affect MySQL's performance?
> Specifically, if I have a database with 1,000 tables in
Hello,
My apologies for repeating a question asked earlier[1] but the
question and the answer were a little vague:
Does the number of tables in a database affect MySQL's performance?
Specifically, if I have a database with 1,000 tables in it, will it
be slower than usual due to the number of t
