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 do you regenerate PSTUXCFG after manually changing psappsrv.cfg?
What program do you execute if you want to run Data Mover from the command line?
Have you done Migration? How to build in PeopleSoft ? Why build from Oracle?
What is nVision Tab?
What do you ‘run’ the Database Wizard?
If the emphasis in PeopleSoft 8 is the internet, why do we still need windows client?
What Web Service software is currently supported in PeopleSoft 8.4?
Where is the setup.exe to install the PeopleSoft components to the Web Server?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
How do you decide between appeng Ci and SQR while conversion?
You configure and boot the domain from the command line. Why did more processes than expected start when the domain was booted?
What is the difference between the 7.5X Vs 8X security?