You connect to a database and then issue your queries. So you
should hold all tables within one database that will be addresses
within one query.
Besides this, it is a matter of taste. Think of it this way: will
it affect performance if you put 1000 files in a directory or
just two of them and allocate more directories instead?
Personally, I don't see any reason to set up more than one
database. I have some 100+ tables now. As long as I see what
things are and mean, I have no problem.
Sie schrieben am Dienstag, 10. Juli 2001, 22:07:25:
> Hey all,
> This seems like a silly, but rather fundamental question. Should I have
> many databases running inside one instance of Mysql with fewer tables in
> each, or should have only a few databases with many tables in each (one to
> many or many to one, more or less)???? Does is matter if the tables don't
> really relate in any way??? Since I've never quite had this perspective
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php