in reply to Connecting to Multiple Databases vs A Single One

With most database systems, mysql included, every table lookup can be qualified with a database (aka schema in other systems) name.

SELECT * FROM Members.access WHERE ...

As long as you have access to each of the schema you're accessing you can do it from a single database handle. It's essentially a way of fully qualifying the table name.

If it makes sense to split your tables across several schema then do so; perhaps there's some logical grouping that makes sense. However, if you're just doing it because 60 seems like an awful lot of tables I'd recommend against it; your groupings will probably turn out a little arbitrary, and database systems don't typically have a problem with that many tables in one schema.

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.