MySQL ODBC Connector - Single or Multiple database performance?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Single or Multiple database performance?

Jim S.

2005-09-16, 8:23 pm

I run a fairly high traffic community web site and my current MySQL
database structure uses a primary database for the majority of
tables/data, but there are some supporting applications that were
installed to seperate databases.

My basic question is, is this the best scenario or is having all
applications using a single database for a single site less taxing
(connections, etc).

If breaking up data into seperate databases is actually a good thing I
have several tables I could migrate out of the primary database as well
(which has 143 tables and is about 370MB at this point).

Thanks,
Jim

Jim S.

2005-09-27, 8:23 pm

Ack...is this not a good group to post a question like this? If so
maybe someone can direct me elsewhere?

Thanks,
Jim

Sponsored Links