RE: PUR500 Performance

Purchasing month-end ran monthly.  Uncosted PO's deleted after 4 months so
the tables are clean from that point of view.

HPH circa  6,700 records
HPO circa 27,000 records

Regards
Mark Curtis
IT Director
Hafele U.K. Limited
Direct : +44 (0)1788 548557
Tel    : +44 (0)1788 542020
Fax    : +44 (0)1788 541860
Mobile : +44 (0)973 121135
email  : mailto:mark.curtis@hafele.co.uk
Web    : http://www.hafele.co.uk


Funny you should mention that.  Don't know if it's the case for you, but I
just left a client that had _HORRIBLE_ performance in _ALL_ of their PUR
modules.  Turns out they hadn't run Purchasing month-end since last April,
thus a "bazillion" P/O's and requisitions were sitting out there waiting to
be purged.  The performance improvement after month-end would have been even
_MORE_ significant had they bothered to delete those items that had been
sitting out there since 1998...


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---