[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: PeopleSoft W-2 SQR

Jim Womeldorf
Programmer/Analyst
Fastenal Company
jwomeldo@fastenal.com
(507) 453-8250


-----Original Message-----
From: SJohn22151@AOL.COM [mailto:SJohn22151@AOL.COM]
Sent: Friday, December 07, 2001 5:58 AM
To: SQR-USERS@list.iex.net
Subject: Re: PeopleSoft W-2 SQR


I worked with the W-2 process in Houston and experienced similar performance
issues.  There's dynamic ORDER BY SQL that may be modified.  There are also
indexes that may be dropped during the INSERT phase. I was able to get the
process down from the same twenty-five hours to ninety minutes.  Good luck.


HTH,
Steffon Johnson
The Business Systems Professionals, LLC
TheBSPs@aol.com