Interested to Buy Any Domain ? << Click Here >> for more details...
What is Performance tuning of SQR?
- 3 Answers
- 9768 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 are the various documents you need to become familiar with prior to the installation?
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?
How will you enable SMTP on Application Server?
Where is the setup.exe to install the PeopleSoft components to the Web Server?
You’ve manually edited the psappsrv.cfg file. Will the domain recognize the changes?
How is PeopleSoft able to provide a database for customers on so many different database platforms?
Name the Tuxedo / Jolt Process and describe their functions?
what are the differences between development view and upgrade view?
You want to change a Application Server name and the WebServer which file will you modify and where?
What is included on the People Tools CD-ROMS?
Describe two SQR reports you can run to check the integrity of the database?
What port does the Web Server use?
PeopleSoft HRMS 
