I have a Mysql DB schema which consists of some core tables in a database
'core'.
Then I have about 22 separate databases which have between 20 - 150 tables a
piece. I normally will stay within one of the daughter databases but
occasionally have to mine data from one of its sisters. I would rather not
change the currently selected database via a 'USE dbname' command but would
rather use the dbname in the select. Example:
SELECT alias.id FROM dbname.tablename AS alias WHERE...
My question is how inefficient is that? I am concerned with switching
databases frequently because I don't want to use hundreds of file
descriptors - I have modified the default variables in my.cnf and increased
the ulimit in safe_mysqd (using FreeBSD). However, I simply don't want to be
using tons of file descriptors that will only be interfaced with once.
-Rob
---------------------------------------------------------------------
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
