SQR - General Performance Tips

["Terry Cheung." <Terry.Cheung@BMG.CO.UK>]

Hi ,


I am in the process of writing a picking sheet report for a warehouse. It
needs to generate 10,000 - 30,000 reports in 8 hours.

As a result performance is a major issue. I will be greateful if you SQR
gurus out there can give me some tips and advice on performance during
development of SQR (v4 for UNIX on SYBASE):

In general, is it faster to perform calculations within the SQR code or
faster by calling store procedure on SYBASE server?

Any tips and advice would be welcome!

>       Thanks in advance,
>
>       Terry Cheung - Bertelsmann mediaSystems
>       BMG Distribution, Unit 24 Crystal Drive, Warley, West Midlands, B66
> 1QG, United Kingdom.
>       * terry.cheung@bmg.co.uk
>       * terry.cheung@bertelsmann.de
>       * Tel: +(44)-121-543-4276
>       * Fax: +(44)-121-543-4393
>
>
>