On 09.02.2001 12:01:01 Kissandrakis S. George wrote:
> I have 6500 tables under one database there is no problem
Pardon me, but how do you keep track of that many tables? I mean, I've a hard
time with 10 or 20 tables - but 6500???
---
I have 6500 tables under one database there is no problem
i hope that helps :)
--
Kissandrakis S. George [[EMAIL PROTECTED]]
Network and System Administrator [http://www.phaistosnetworks.gr/]
Tel/Fax: (+30 892) 24450/23206
Phaistos Networks S.A. - A DOL Digital Company
---
I think 12 tables is not a large number by any means.
If they _logically_ form one database, I'd not bother about the number.
Only if performance problems pop up, and are positively recognized as being caused
by too many files in the database directory, I'd start looking for a solution.
Which need
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in o
>
> How do you decide when a table should go into another database. For
> example, I have a database with about 12 tables and growing. I keep
> them in one database because I am doing joins that periodically involve
> all of the tables. Is this the right way to do it?
>
> Richard
Richard, I'
