Re: [sqr-users] sqr tuning question

["Jerry Coleman" <colemanj@washpost.com>]

This is how I understand it:  Your statement in SQL*Plus is being executed
(build a result set on the server) and fetched (deliver those results to
you).  SQR is doing the same thing, however, for every row fetched, you're
going off and doing "lots of processing" with that row.

Speeding things up in a case like this might mean updating as much as you
can in one transaction, as opposed to row by row.  But you would lose the
granularity of the data for reporting.





|---------+---------------------------->
|         |           MBAUTIGER@aol.com|
|         |           Sent by:         |
|         |           sqr-users-admin@s|
|         |           qrug.org         |
|         |                            |
|         |                            |
|         |           12/05/02 11:16 AM|
|         |           Please respond to|
|         |           sqr-users        |
|         |                            |
|---------+---------------------------->
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                 |
  |       To:       sqr-users@sqrug.org                                         
                                 |
  |       cc:                                                                   
                                 |
  |       Subject:  [sqr-users] sqr tuning question                             
                                 |
  
>--------------------------------------------------------------------------------------------------------------|




Hello,(Oracle, Unix)I have a select statement that takes around 7 seconds
to complete in SQL*PLUS.  In my SQR I use the sql statement and do lots of
processing for each row returned(total of couple thousand rows).  The
program takes a long time to complete and I am wondering how SQR handles
selects in the Begin-Select paragraph.  Can I basically take the number of
rows and multiply by 7 seconds and thus have my issue (that would mean
several hours) or does SQR run the begin select only once which would mean
around 7 seconds.  I know the timing will not be exact but I'm just asking
in general does SQR run the begin select once to return all the rows store
them somewhere and then process each row one at a time, or does it
physically run the select each time and process each row as it is returned.
Just trying to figure out if I should worry about tuning the 7 second
query.  If it is run only once, then no worries, however if it is run for
each row we would have a major issue h!
ere.
Thanks.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users






_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users