MySQL Performance!
Posted: Mon Dec 04, 2006 12:55 pm
Hello, I'm currently working on a project with a few people and we're currently at a debate on which of the following database structures is faster. Now this is all about a user database, users have a profile, and other information stored in a database. We would like to know which one is faster.
1) Having multiple databases with user details split up, maybe having one database for login information, one for profile information .etc
2) Having multiple tables instead of databases.
3) Having it all in the same table.
Another question is the following also good for performance, having users stored like: users_a, users_b, where the letter is the first character of the users last name. If so, what would be faster, having each table have it's own database, or each table being in the same database?
And the last question! A buddy and me are on a debate about the SQL JOIN command, isn't it true that JOIN is slower then just doing multiple SQL query's?
Thanks,
William
1) Having multiple databases with user details split up, maybe having one database for login information, one for profile information .etc
2) Having multiple tables instead of databases.
3) Having it all in the same table.
Another question is the following also good for performance, having users stored like: users_a, users_b, where the letter is the first character of the users last name. If so, what would be faster, having each table have it's own database, or each table being in the same database?
And the last question! A buddy and me are on a debate about the SQL JOIN command, isn't it true that JOIN is slower then just doing multiple SQL query's?
Thanks,
William