Re: JDBC and Stored procedure performance problems

Coming in late on this thread...

There is an overhead on the iSeries in getting the JVM started, so maybe
this is what you are seeing. You may need to pre-start a bunch of JVM, so
that one is nearly always available. Can't provide the technical details,
but your system admin folk should be familar with pre-start jobs.

Sam

"Mark" <Smits@xxxxxxxxxxxx> wrote in message
news:1136566084.753375.150410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> We are using a connection pooling mechanism but only to reuse the
> connections, not opening them in advance. Right now I am creating a new
> connection if all are in use and opening it in advance. This takes
> about seven seconds off from the waiting time, so it's a step forward.
>
> Activation group is *CALLER, so that is in order too.
>
> The same SQL statement takes just a second in STRSQL, so it's hard to
> believe it takes up so much time in a stored procedure, althoug being
> embed SQL RPGLE. I have timed the JSP and classes but the bottleneck
> seems to be in the single "execute" statement to activate the stored
> procedure and getting back the resultset.
>
> I haven't got around in putting some timing code in the stored
> procedure itself, but will do so next. The delay must be somewhere...
>
> Thanks for the pointers. Opening the connection in advance already
> helped.
>


.

Relevant Pages

  • Re: JDBC and Stored procedure performance problems
    ... We are using a connection pooling mechanism but only to reuse the ... connection if all are in use and opening it in advance. ... The same SQL statement takes just a second in STRSQL, ... embed SQL RPGLE. ...
    (comp.sys.ibm.as400.misc)
  • Re: Inserting into a database
    ... $dbh->do("INSERT INTO TEST2 (sfd, w, sdf, hfg, rt, bv, te) ... Why are you opening the db connection for each file? ... once, prepare your sql statement, and then for each file execute the ...
    (comp.lang.perl.misc)
  • Re: DDE Access to Word using mde
    ... but Word opens just fine. ... to an Access 2002/3 .mde using DDE, the connection is fine. ... By the way there are no other users(except the current opening of the ...
    (microsoft.public.word.mailmerge.fields)
  • Re: JVM not created
    ... But,when using the COM with ASP,opening the page in Browser once it is working fine,but next time when opening it says that JVM is not created. ... separate process. ...
    (comp.lang.java.programmer)
  • Re: Default to LAN connection when Dial-up is present
    ... I no longer have possession of the laptop to try most of this but I can tell ... Outlook Express was not opening ... Our GPO prohibits allowing the user to change the connection settings in IE. ...
    (microsoft.public.windows.inetexplorer.ie6.setup)