Page Processing Efficiency

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 - 01:58:03 CEST