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.

mitra

 Profile Answers by mitra 

• 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

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

sandeep

• 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.

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Nov 15th, 2010

 

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.