[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.
Dean
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