-
May 25th, 2005, 09:58 PM
#1
Junior Member
Database efficiency question
Hi,
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.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|