Focal Point
Anyone having performance problems with 5.2.4

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9941077331

March 27, 2004, 04:10 PM
<billf>
Anyone having performance problems with 5.2.4
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.
March 27, 2004, 04:15 PM
<billf>
Sorry, should have added that the server is running on Widows 2000 SP 6. We use IIS default with the OS.
March 29, 2004, 02:43 PM
<WFUser>
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?
March 29, 2004, 06:28 PM
<billf>
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.
March 29, 2004, 06:55 PM
<WFUser>
1 gig of memory is a bit low. Servlets aren't always faster than cgi. It really depends. IB Support can tell you how to switch back to CGI mode if you want to test that.
March 29, 2004, 08:16 PM
susannah
Your other option with win2k server is ISAPI.
(faster than cgi).
we have lots of issues with 524 as well, but don't have any probs with RA in MRE. we're win2k and servlet.