[sqr-users] on-break Performance

[Roland Ferreras <rferreras@yahoo.com>]

I have an SQR program that will be processing a lot on information and I'm in 
need to tweak it as much as possible.  My question is what's the overhead 
performance of ON-BREAK commands when used in a BEGIN-SELECT block?  I'm 
thinking of rewriting the following code using 'if-then' logic to find my 
breaks depending on the performance.  I have around 5 BEGIN-SELECT procedures 
that I would have to recode.
 
Below is a copy of my code...
 
begin-SELECT on-error = ESG-SQL-Error
LINE.EMPLID             () ON-BREAK level=1 save=$EMPLID
LINE.COMPANY            () ON-BREAK level=2 save=$COMPANY
LINE.PAYGROUP           () ON-BREAK level=3 save=$PAYGROUP
LINE.PAY_END_DT         () ON-BREAK level=4 save=$PAY_END_DT
LINE.OFF_CYCLE          () ON-BREAK level=5 save=$OFF_CYCLE
to_char(LINE.PAGE_NBR)  () ON-BREAK level=6 save=$PAGE_NBR
to_char(LINE.LINE_NBR)  () ON-BREAK level=7 save=$LINE_NBR AFTER=Pay-Line-Break
to_char(LINE.EMPL_TYPE) () ON-BREAK level=8 save=$EMPL_TYPE

FROM PS_PAY_LINE LINE
!-------------------------------------------
WHERE LINE.COMPANY    = $COMPANY
  AND LINE.PAYGROUP   = $PAYGROUP
  AND LINE.PAY_END_DT = $PAY_END_DT
  AND LINE.CONFIRMED = 'Y'
ORDER BY LINE.EMPLID
        ,LINE.COMPANY
        ,LINE.PAYGROUP
        ,LINE.PAY_END_DT
        ,LINE.OFF_CYCLE
        ,LINE.PAGE_NBR
        ,LINE.LINE_NBR
end-SELECT


FYI I'm running this in a Windows 2000/Oracle 9 shop.

Thanks!  

Roland

 



"If you are going through hell, keep going." 
   - Sir Winston Churchill (1874-1965) 

---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

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