[sqr-users] sqr tuning question

[MBAUTIGER@aol.com]

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 here.
Thanks. 

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