We haven't targeted performance yet- it is coming soon. We are happy with ODBC performance via SQL and stored procedures to the 400 from PC client apps. So far, we are dissapointed (and surprised) with initial performance of an applet which communicates with servlets running under WebSphere (via the HTTP server) which in turn use JDBC access. We have not yet pinpointed the bottleneck(s) so it is too early to say where the problem lies. I don't doubt that record level access is faster, but it doesn't suit our particular requirements. On the other hand, we also have some servlets which respond with HTTP/JSP and access the database with the toolbox JDBC drivers to execute stored procedures, and except for the first time they are run after starting up, the performance is fine. Anyway we have a lot of hunting to do. If we are not happy with the end result, then Rochester has some work to do IMHO. I expect performance via JDBC to be at least as good as with ODBC on the 400 (actually, better if I use the native DB2 drivers directly on the box), especially if Rochester wants to market the 400 as THE java server. Anyway, I have yet to crack open the V4R4 performance guide, but it has chapters on each of the components involved in our system.
----- Original Message -----
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.