[Theforum] [---Dev] RE: [---tent] Article cleanup issue

Matt Liotta mliotta at r337.com
Tue Jul 23 23:34:57 CDT 2002


> definitely, if you send them over as separate queries, you have this
> potential connection problem, but what's worse, far worse, is that you
> would have to re-execute (nearly) the same JOIN and WHERE logic to
come up
> with the count
>
This is not a problem with CF since there is no direct tie between query
execution and database connection opening and closing.

> not every optimiser is going to solve both result sets with the same
pass
> of the data, but if any can, oracle can
>
Although you may need to give it a hint depending on your query.

> but then, with query-of-query in cf, you wouldn't run the count uery
> against the database, would you   ;o)
>
It all depends as CF's query-of-query is quite slow as compared to a
real database with a query optimizer.

> yes, john, coldfusion's query caching is a thing of beauty
>
Only when used correctly. IMHO, this is an incorrect use.

> i'm surprised nobody has mentioned query-of-query -- you know, with a
more
> generalized result set (e.g. not including recent comments or similar
> dodgy
> stuff) the cache could last even longer (theoretically not until
another
> article changes status) and then the category lists, author lists, and
> other stuff could be driven off the main cached article list without
going
> back to the database either...
>
This is why a materialized view would be better as the view could
automatically be updated when the data changes.

-Matt




More information about the theforum mailing list