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 |
How to refresh PeopleSoft security from one Instance to another?
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 is included on the People Tools CD-ROMS?
You’ve manually edited the psappsrv.cfg file. Will the domain recognize the changes?
What is the Tux IPC Helper?
What are the different types of databases, why do they differ, and what is the purpose of each?
Why use internet access as the client for PeopleSoft application?
What are the three logical sets of tables that make up a PeopleSoft database and what is the purpose of each?
You configure and boot the domain from the command line. Why did more processes than expected start when the domain was booted?
Describe two SQR reports you can run to check the integrity of the database?
i want to know the trainnig instittutie of people soft in pune?
Name the Tuxedo / Jolt Process and describe their functions?