Re: PUR500 Performance

["David Shea" <dshea@xxxxxxxxxxxx>]

So you have virtually NO data and the performance is still horrible?  Are
your numbers only active records, or are those the total physical file
record counts?

Have you looked at an executing transaction in detail?  Is it doing a lot of
physical I/O or just racking up CPU time without I/O?  If it's doing I/O,
look at which files are getting the activity and look into purging/archiving
those files.  If it's spinning up CPU time without any I/O, look at any SQL
or OPNQRYF activity that might be going on and try to either fix the code or
purge those files.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Purge and Archive your AS/400 Data Without Programming with ARCTOOLS (tm)
DCSoftware, Inc.
(508) 435-8243
(508) 435-4498 (fax)
http://www.arctools.com
mailto:info@arctools.com
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

----- Original Message -----
From: "Mark Curtis" <mark.curtis@hafele.co.uk>
To: <BPCS-L@midrange.com>
Sent: Friday, January 14, 2000 5:17 AM
Subject: 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
> +---
>

+---
| 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
+---