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 port does the Web Server use?
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 Performance tuning of SQR?
What are the various documents you need to become familiar with prior to the installation?
What file created when you choose to create a domain in psadmin? From what order files is it created? Where is it located?
Where is the setup.exe to install the PeopleSoft components to the Web Server?
What is Tnsnames.ora?
For each PeopleSoft application that is installed, the installer creates two databases. What are they? Explain?
What is PeopleSoft Internet E-Business?
How is PeopleSoft able to provide a database for customers on so many different database platforms?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
What are the three logical sets of tables that make up a PeopleSoft database and what is the purpose of each?