Re: Page Processing Efficiency

use bind variables. Lot of cold fusion folks don't and it hurts their scalability. Cold Fusion does support it. Jim
"Michael Hill" <hillmw_at_ram.lmtas.lmco.com> wrote in message news:3F95C80B.30A66D28_at_ram.lmtas.lmco.com...
> If I had a page that was being generated using coldfusion from queries
> to an oracle table would it be better response time:
> A) pulling the all the data using 1 query and iterating over the same
> result table multiple time producing desired arrays, or
> B) pulling specific data using specific queries with less production of
> arrays and proccessing after te data was returned?
>
> In the example I had 2 date fields called start and comp in a table with
> other like data and wanted to know what the min value was from both
> fields.
>
> So I have to "select * from the table where mynum='131'" and then
> process the result set
>
> or
>
> "select * from the table where mynum='131'" as well as 2 more queries:
>
> "SELECT min(min_start) as min_start
> FROM
> (
> SELECT min(BASE_START) as min_start
> FROM TASK
> WHERE my_NUM = '131'
> UNION
> SELECT min(ACT_START) as min_start
> FROM TASK
> WHERE my_NUM = '131'
> )"
>
> and
>
> " SELECT max(max_comp) as max_comp
> FROM
> (
> SELECT max(BASE_COMP) as max_comp
> FROM TASK
> WHERE my_NUM = '131'
> UNION
> SELECT max(ACT_COMP) as max_comp
> FROM TASK
> WHERE my_NUM = '131'
> )
> "
>
Received on Wed Oct 22 2003 - 06:08:10 CEST