What is Performance tuning of SQR?
- 3 Answers
- 8512 Views
- I also Faced
- E-Mail Answers
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?
Did you worked with functions, procedures in SQR?
Where is the setup.exe to install the PeopleSoft components to the Web Server?
What are the PeopleSoft components for the Web Server?
What is Application Designer?
What is IVT?
What is the importance of the queue status?
what are the differences between development view and upgrade view?
What is Spawn Threshold?
You Migrate some page changes from development to test environment but still the user complaints the changes are still not reflected in the test environment. What could be the problem and how will you resolve it?
What are the different types of databases, why do they differ, and what is the purpose of each?
For each PeopleSoft application that is installed, the installer creates two databases. What are they? Explain?
PeopleSoft HRMS 
