When switching from CGI to servlet, I found that performance went from reasonable to extremely poor, with some reports that ran in 5-7 seconds with CGI taking minutes to run with servlet (or timing out).

Has anyone else experienced this problem, or know what might be causing it? Is it a known problem that has been fixed with a more recent software version?

Here is my WebFocus environment:
WebFocus 5.2.3
Unix - IBM AIX 5.2
Apache 1.3.27
Tomcat 4.1.24
Oracle 9.2.0.6

Any help/suggestions would be appreciated!

Thanks,
Sean

generally speaking, ISAPI beats CGI (by miles), and Servlet is sometimes better than ISAPI (or at least equals); but that opinion is a win2k one; Perhaps you should open a case with tech support and have them take a look at your install and config, since your findings seem to be counter to the norm. They'll be best able to help you.

Thanks Susannah,

I actually have a case open, but they're starting by looking at some code and not the config. I agree that there may be something wrong with the config, especially when you say that you expect Servlet to be faster than CGI.

Thanks for your input!

I'm using release 5.2.4 and though Information Builders claims that Servlet is faster, I always find CGI to be faster. I'd be interested to know what the outcome is.

Thanks much,
Carol

Carol,

I'll post a note if we find a solution.

We've reverted our Prod env back to CGI in the interim.

Regards,
Sean

The solution was to set &ECHO off. For fexes that perform a lot of processing, Servlet couldn't handle it. But this has been fixed in WF 5.2.7.

But it's a good idea to turn off &ECHO for Production anyways.

Also, I am told to refrain from the use of -TYPE.

I've also been told that Servlet performance (in general) is much better in 5.2.7 than 5.2.3.

Regards,
Sean

Sean,
Many thanks for posting the outcome. I use &ECHO in EVERYTHING! It's good to know it's not the installation, and for this release we'll stick with CGI.

Thanks again!
Carol

Just curious what method are you specifying when calling WFServlet? Get or Post?

We are starting to explore implementing 7.1 under websphere. Any performance tuning tips would be appreciated.

We use POST.

Regards,
Sean

We use POST also, but with CGI