RE: OW R31802 performance issue

david_mallory

Well Known Member
RE: OW R31802 performance issue

The F0911 file is GL transactions and will have every line ever sent to the
GL until you archive some of it, like two years and more back. So it is a
huge file, never empty.

You may have mfg transactions to GL set to write in detail (each transaction
line from source program goes to GL as a separate entry) instead of writing
summary entries by BU/object/sub combination. This is a processing option.
Downside of summary entries is, it puts another step in the process when
tracing a source entry to GL when you are debugging an application or the
accounting folks are tracking down a problem. We run all out apps with
"write to GL" set to "detail" and do not see a performance problem. We run
fat clients: not a big shop.

Dave Mallory Denver Water 7332 SP 13.3 Oracle 8.05 NT 4.0 Intel
 

hotm6654

Well Known Member
Re: OW R31802 performance issue

We applied this ESU and it has made a HUGE difference.


----- Original Message -----
From: "david mallory" <david.mallory@denverwater.org>
To: <jdelistml@jdelist.com>
Sent: Thursday, February 08, 2001 9:54 AM
Subject: RE: OW R31802 performance issue ~~0:5272


> The F0911 file is GL transactions and will have every line ever sent to
the
> GL until you archive some of it, like two years and more back. So it is a
> huge file, never empty.
>
> You may have mfg transactions to GL set to write in detail (each
transaction
> line from source program goes to GL as a separate entry) instead of
writing
> summary entries by BU/object/sub combination. This is a processing option.
> Downside of summary entries is, it puts another step in the process when
> tracing a source entry to GL when you are debugging an application or the
> accounting folks are tracking down a problem. We run all out apps with
> "write to GL" set to "detail" and do not see a performance problem. We run
> fat clients: not a big shop.
>
> Dave Mallory Denver Water 7332 SP 13.3 Oracle 8.05 NT 4.0
Intel
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
5272
> *************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
>



JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100
 

DEvans

Active Member
Re: OW R31802 performance issue

which ESU did you apply as our R31802 is currently running for nearly 8 hours!
 
Top