Always learning...
I am writing a db that has a table with advertisement data. I want to keep track of how many views an ad has.
Is it bad practice to put a field "viewCount" in the same table as the content? The alternative is to have a lookup table?
The logic behind the question is that it seems that any time you write to a table there is a possibility of something going wrong, so better to leave the content alone and update a lookup table often.
Or am I being over-cautious?
Thanks in advance for your thoughts.
Steve
- I have fun with telemarketers
I am writing a db that has a table with advertisement data. I want to keep track of how many views an ad has.
Is it bad practice to put a field "viewCount" in the same table as the content? The alternative is to have a lookup table?
The logic behind the question is that it seems that any time you write to a table there is a possibility of something going wrong, so better to leave the content alone and update a lookup table often.
Or am I being over-cautious?
Thanks in advance for your thoughts.
Steve
- I have fun with telemarketers
