Jump to content

Two tables or one for user details and postal addresses?


ordinaryToucan

Recommended Posts

(Using MySQL5.0) I have a question, for which I would be grateful to receive wisdom / opinions / ideas...

 

I want to store basic details (email, firstname, lastname, etc.) for about 50,000 users - about 20% of which will include (up to two) postal addresses. Is it better to store the user details and user addresses in separate tables, or in a single table?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.