Several Tables or 1 Table ?

[Duane Hookom]

1

 

[Gwen]

Hello Everyone,

I need to store data for these fields.
phrase
search
results
date

phrase searches results date
thing 100 1000 jan 1, 2005
some thing 20 250 jan 1, 2005
other thing 17 289 jan 1, 2005
another thing 1000 1000 jan 1, 2005

I need to calculate % change on the phrase searches and results on each data
set.
The data set will ran on a daily, weekly or monthly basis.

My idea is to store the data in a separate tables by date.

Do you think this is the best table design?

Thanks

Gwen

 

[rolaaus]

If you are storing each individual search for an item, then you don't need to
store the summary information at all, unless the summary data is being
queried so often that it will degrade the performance of the db, otherwise
just setup some total queries and total them by week, month, etc.

 

[rolaaus]

If you are storing each individual search for an item, then you don't need to
store the summary information at all, unless the summary data is being
queried so often that it will degrade the performance of the db, otherwise
just setup some total queries and total them by week, month, etc.

 

[Gwen]

Thanks

1

 

[Gwen]

Thanks

If you are storing each individual search for an item, then you don't need
to
store the summary information at all, unless the summary data is being
queried so often that it will degrade the performance of the db, otherwise
just setup some total queries and total them by week, month, etc.