Having problems with message search?
Hello *,
I was wondering if I could control the PPLsoft performance
by partitioning of the PS_LEDGER and / or PS_JRNL_LN tables.
I have done the obvious other performance optimalisations
and I identified and removed several bottlenecks both in SQL statements and database
instance setup, effectively doubeling the speed. So performance is fine and not
an urgent issue anymore. However I would like to forecast the performance of
the database in the range 1 to 3 years based on the past data growth. I know
that archiving the peoplesoft tables is the normal way of application
management, but such archiving project is not feasible due to budget
constraints.
So I need a way to maintain the present performance, not
increase it. If this is not possible, forecast the performance.
Therefor I was wondering :
(1) if I could
enforce a more durable performance control by partitioning of the PS_LEDGER and/or
PS_JRNL_LN tables.
(2) How can I fill
my testdatabase with extra data to simulate the future database?
Thanks for any pointers,
Willem Leenen
----------------------------------------------------------------- ATTENTION: The information in this electronic mail message is private and confidential, and only intended for the addressee. Should you receive this message by mistake, you are hereby notified that any disclosure, reproduction, distribution or use of this message is strictly prohibited. Please inform the sender by reply transmission and delete the message without copying or opening it. Messages and attachments are scanned for all viruses known. If this message contains password-protected attachments, the files have NOT been scanned for viruses by the ING mail domain. Always scan attachments before opening them. -----------------------------------------------------------------
Send Email
