[thesite] dean, some oracle things again..
Daniel J. Cody
djc at starkmedia.com
Thu May 17 17:06:08 CDT 2001
ya, i meant index.. that updated every 5 minutes.. or better yet, a
trigger that rebuilds the index when a an article is updated..
jeff wrote:
>
> 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.
>
> my 2c,
>
> .jeff
>
> name://jeff.howden
> game://web.development
> http://www.evolt.org/
> mailto:jeff at members.evolt.org
>
> _______________________________________________
> http://lists.evolt.org/thesitearchive/
> and new & improved kentucky fried old archives:
> http://lists.evolt.org/thesitearchive/old/
More information about the thesite
mailing list