load testing UIX-XML/BC4J
We're doing some load testing, on a small R&D server. OC4J 9.0.2 on top of 9iAS 1.0.2.2.x.
We created a simple BC4J JSP insert page, and got good performance up to 100+ users, once we reduced the maxpoolsize from enormous (which used up more DB connections than the database could handle) down to 25 or 50.
We've also gotten good performance for that many users from a JSP page coded using JDBC. There, we needed to make sure we cached the JINI lookup for the data source (otherwise, we crashed 9iAS).
Now, we're trying a BC4J UIX-XML page, and it's crashing. This is a view page, pretty close to the one generated by the JDev 9.0.2 production Wizard (I changed some layout). We're just doing a read-only test: loading the page, waiting a few seconds, and loading it again). By the time we get to 40-50 virtual users on jmeter, we're seeing page refresh times rise from 1-2 seconds up to 30 seconds or so, and having BC4J fail to check out an Application Module instance. I'm assuming all the instances are used up with existing sessions at that point.
With a few users, it's great. With more, it's causing problems.
I'm assuming we're doing something wrong, in BC4J, uix, or OC4J configuration. I'm not sure what, though. Any help would be appreciated.
We haven't tried to put in anything about state anywhere, just used any defaults in BC4J or UIX.
-- jim