peterbruce
Legendary Poster
JDEList,
We have a problem where the Revise Unposted Entries (P12102) inquiry times out on the web client before returning data. I tracked this on the fat/admin client using the debug log and the sql statment took 8 minutes to return. However, when the same sql is executed on an oracle client it took 2 minutes. I am concerned about the difference.
In addition (this may be the wrong forum for this so I will post it on the applications forum), I would like to know how others use this application and how it performs. Our F0911 has about 15 million rows which I believe is quite small compared with some large organisations. Further, our users click the find button without adding any extra parameters.
On previous occaisions we have added a new index and done column analysis on the F0911. This worked initially, but as the table grows, the problem re-surfaces.
Any comments or advice is most welcome.
We have a problem where the Revise Unposted Entries (P12102) inquiry times out on the web client before returning data. I tracked this on the fat/admin client using the debug log and the sql statment took 8 minutes to return. However, when the same sql is executed on an oracle client it took 2 minutes. I am concerned about the difference.
In addition (this may be the wrong forum for this so I will post it on the applications forum), I would like to know how others use this application and how it performs. Our F0911 has about 15 million rows which I believe is quite small compared with some large organisations. Further, our users click the find button without adding any extra parameters.
On previous occaisions we have added a new index and done column analysis on the F0911. This worked initially, but as the table grows, the problem re-surfaces.
Any comments or advice is most welcome.