Storing Massive Results

This is a sample of some data that is a result of a SELECT that calculates the total number of sites that referred traffic to our websites.

What I would like to do is store these results in another table so that my boss can simply SELECT that results table and get the report.

Is this good practice? I need your opinions.

Thanks

Code:

---

coralridge.org        52        4549        4549        0
-        36        3200        3199        1
216.247.64.85        5        499        499        0
65.240.226.68        1        97        97        0
crministries.org        0        84        84        0
google.com        0        43        43        0
search.yahoo.com        0        19        19        0
search.msn.com        0        16        16        0
oneplace.com        0        14        14        0

---

Depends how up-to-date u want the data. You will have to recreat your summary table ach time the boss wants the new figures.

j4u -

Create a view instead. Then your boss can execute

'Select * from myview;'

A rollup temp table requires periodic (usually daily) updating, and you should consider using it only when:

1. it takes forever to retrieve the data from the real source
2. you boss won't care if it's data from last night's run.