I am working on a site which has a large number (around 24000) of GL accounts due to account segmentation and as a result, a number of functions are very slow, for example, opening the budget scenario definition screen takes around 5 minutes.
I have upgraded the database to 8.8, PL12 on a test server, which has increased the performance slightly, but it is still takes about 3 minutes to open the budget scenario definition screen.
That screen is just one example, anything to do with the accounts is slow, even opening the General Ledger report selection screen
I have proved that it is the number of accounts in a test system by deleting all accounts that have never had any postings in jdt1 which halved the total number of accounts, and increased the system performance dramatically
Has anyone come across this performancee problem bofore?
Edited by: Arran Bishop on Sep 8, 2010 8:34 AM