Forum Moderators: open
What do you see as the pros and cons of each option?
Thanks
For example, let's say that several months down the road you realize that you really should have included logging the IP address with each post. Now you have to go back and add an IPAddress field to every relevant table.
Con: If you have a search capability, you have to search multiple tables instead of just one.
For example, you delete a user who has been spamming your site. You have to go through every table and delete his messages.
Con: If you later decide you need to add a field (or change the structure of an existing field) to all the tables, you'll have to add/modify each table instead of one central table.
For example, let's say that several months down the road you realize that you really should have included logging the IP address with each post. Now you have to go back and add an IPAddress field to every relevant table.Con: If you have a search capability, you have to search multiple tables instead of just one.
For example, you delete a user who has been spamming your site. You have to go through every table and delete his messages.
All true...unless you use triggers ;-)
JAG