What is Performance tuning of SQR?
Answers were Sorted based on User's Feedback
Answer / naresh
Performance tunning can be done with Loadlookup,using with
arrays,cross tabular reports,multiple reports,running on
server
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sridevi bandi
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.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ravi kumar garre
If u r Creating multiple reports (More than 2 pdf files)
then better use Temparary tables ..it will show u the
performance
| Is This Answer Correct ? | 1 Yes | 2 No |
What dose the Database Wizard do?
What Web Service software is currently supported in PeopleSoft 8.4?
What is Spawn Threshold?
What is an Application Server Domain?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
What does port 3050 resolve to as hexadecimal?
What are the different types of databases, why do they differ, and what is the purpose of each?
i want to know the trainnig instittutie of people soft in pune?
How to refresh PeopleSoft security from one Instance to another?
How do you include SQCs in middle of the program? Is it possible ?
You’ve manually edited the psappsrv.cfg file. Will the domain recognize the changes?
Briefly describe PeopleSoft and Non PeopleSoft objects?