Performance tuning of SQR?

Showing Answers 1 - 5 of 5 Answers

sandeep biswas

  • Jul 10th, 2005

sqr performance is mainly depends upon sql accessing the database 
to increase the performance 1. we need to break the sql into pieces and put logic . avoid long joints.

  Was this answer useful?  Yes


  • Sep 22nd, 2005

Performance tuning in SQR can be done using the following

1.Load-lookup cmd

2. Arrays

3.Multiple Reports

4.-Bnn flag

5.By running SQR progrm on server

6.By running SQT files

  Was this answer useful?  Yes

R.Guru Lakshmi

  • Jan 31st, 2006

1.Load Look Up, Look Up2.Arrays3.Multiple Reports4.-Bnn5.Using SQT Files6.Run on the BATCH Server7.Proper Programming Logic8.Set processing9.SQL Tuning

  Was this answer useful?  Yes


  • Apr 4th, 2007

For performance tuning in SQR first we need to tune up the sql,use appropriate joins with nessasary conditions.Then use nessasary functions for low execution time and use temp tables for bulk data transactions.

Simplify complex select statements.
We can use load-lookup to simplify joins.
Use dynamic sql instead of a condition in a select statement.
One program can create multiple reports simultaneously.
We can save compiled programs and return them with sqr execute.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions