Performance of P03B102

[LostinOW]

Is anyone else experiencing slow performance with Standard Receipts Entry (P03B102). On our system applying payments is excruciatingly slow.

Frank

OneWorld Xe + XU1 SP 15_010, AS/400 V4R4M0
Windows 2000 SP2, SQL2000 SP1,
Citrix Metaframe 1.8A SP1

 

[rgz]

We also had it running slow. After adding a number of custom indexes, it's
flying.
To find the indexes you need, turn debug on the client, capture the select
statements at the time P03B12 is slow, and run them individually against the
as400 in sql (with debug on). The optimizer will then return a list of
suggested indexes. Create the indexes using CREATE INDEX in sql, and finally
delete the sqlpkg's. The new indexes will then kick in.
It's a slow and painful way of finding missing indexes, but it does work.
On the KG, under Knowledge Browser, there's some documents that describe the
above, as well as how to capture missing indexes system wide.

 

[LostinOW]

I went through all the work of finding useful indexes. I build two new indexes and deleted the SQL packages. I did get some performance improvement, but not nearly enough to warrant the effort. The program is still very slow.

Frank

OneWorld Xe + XU1 SP 15_010, AS/400 V4R4M0
Windows 2000 SP2, SQL2000 SP1,
Citrix Metaframe 1.8A SP1