I would suggest a combination of both. Have a table with a structure
similar to the following:
TABLENAME: Weekly Hits
Cols: ID_Property, week_start, hits
This way, you would have a new row for each property each week. It's
also easy to expand you search. If you want to see how many hits a
property got between March and June, say, that's an easy query to make
(select sum(hits) from weekly_hits where week_start > '01-mar-03' and
week_start < '30-jun-03' and prop_id = 42).
Hope this helps,
Jeffrey Melloy
