From: hillmw@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'   
     )   
   "   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)