May 25th, 2005, 09:58 PM
Database efficiency question
We are developing an online application that will, among many other things, be taking a user's mailing and billing addresses.
I was wondering, which is better:
1) storing both addresses in the same table as the user account
2) creating a seperate table to store just addresses (and user_id)
I realize that one may be better depending on the situation, but what are the drawbacks of doing it either way?
Oh, and we are using MySQL 4.1.11 with InnoDB tables.