[thesite] dean, some oracle things again..

Dean Mah dsmah at home.com
Thu May 17 17:23:38 CDT 2001

You might want to take a look at using a materialized view in Oracle
8i.  I've never used them before myself but they build summary tables
of data, basically caching.


jeff writes:

> djc,
> :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> : From: Daniel J. Cody
> :
> : also , the front page query is taking like
> : 20 seconds to run.. can we make a view out
> : of this:?
> :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> we can make a view out of it, but that won't give us any speed increases.  a
> view doesn't actually create another table of info to query, it just binds
> together some sql logic into a  resultset that can then be queried with
> simpler queries.
> my suggestion would be to take that query and make a stored procedure out of
> it.  then we'll get the speed of advantage.

More information about the thesite mailing list