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 |
Briefly describe PeopleSoft and Non PeopleSoft objects?
What port does the Web Server use?
Why use internet access as the client for PeopleSoft application?
What is the importance of the queue status?
What is the Tux IPC Helper?
What are the client names when you execute a client status in psadmin?
What does port 3050 resolve to as hexadecimal?
What is IVT?
What Web Service software is currently supported in PeopleSoft 8.4?
What must be installed prior to running the PeopleSoft installer?
Where is the setup.exe to install the PeopleSoft components to the Web Server?
What is nVision Tab?