We recently upgraded from 4.3.6 to 5.2.4 and now 5.2.5. We are having bad performance problems relative to 4.3.6 with MRE in two areas. First in opening the Report Assistant we see a long delay (20 seconds) to launch the report assistant. Then we see upwards of 1 minute delay when running a report from report assistant. The report run delay is not evident when running a report via a direct CGI call.
Anyone else seen this? The server config and databases are the same from 4.3.6 to 5.2.4.
Is it only the first time it's run, or is it every time? If it's only the first time, that would make sense with the servlet. If it always happens, then there is some other issue. How much memory is available on the machine? How many CPUs?
It seems to be quit bad on first run. However subsequent runs of Report Assistant are also much slower than in 4.3.6. The machine is a dedicated 600 Mhz (older machine) running 1GB of RAM. It is using maybe 500MB of the RAM and the CPU is never more than 30% peak busy at any given time.