PeopleSoft, Show Us Some Love
Posted On: 12/15/2006
In my article Enlightened Performance I
discuss some of the techniques for set-based processing,
and how PeopleSoft does it in a platform-independent
manner. Now, the horror stories.
The purpose of the field Process_Instance is two-fold:
first, it provides a clear, logical way to place row-level locks
on sets of data, and second, it provides a highly-cardinal
field which can be indexed to improve the performance of
batch code. So, why does batch code get slower and
slower? First, PeopleSoft often fails to place an index on
Process_Instance. Second, and bewilderingly, sometimes
batch code (particularly in Receivables) sets the value of
Process_Instance back to zero, effectively destroying the
To continue reading this article you must have a current VP1 Subscription.
