RE: Cash Receipts R03B551 more than doubled run time in ERP8 from

RE: Cash Receipts R03B551 more than doubled run time in ERP8 from

Thank you for your response, however I don't understand what you mean. What
statistics in what database? Do you mean the Statistical Build in AR? The
F03B16(S) files. If so, there is tons of data in there because we built the
new environment from our production environment.


Thank you ever so kindly,

Barbara

Barbara,
This is a technical issue not in JDEdwards and also in database. All tables in database has indexes to perform a faster reads. The statistics in database told the DBMS the best way to make the access, if you have for example 1.000.000 rows in F03B11 and you search for a DOC, DCT and KCO the access is faster because has a index.
When you submmit a request into database, the database will decide wich is the fastest way to access, using a index ou reading all table (also called full scan). This decision of how to access will be based on statistics. For example is the statistics has that F03B11 has 200 records and in database exists 1.000.000, the decision is to read all records because the table is small (but this is not true) the table is a monster and will expend a lot to perform a single read.
Please talk with your DBA in project to review this. This is a big pain in the neck in migration.

Hope this help.