struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shailender Jain" <shailender.j...@teleatlas.com>
Subject Re: executeBatch
Date Mon, 26 Jul 2004 07:09:08 GMT
Only 8 seconds!!!
The records i am trying to insert are simple.  Some 11 comluns values needs to be inserted.

What set up i needs to check?
How to check the leakage of resources?

Also want to share that when i increased the batch size to 500, i got this Error

"Statement Length Exceeds Maximum"

tiwari.rajeev@wipro.com wrote:

> Hi Shailender,
> As per me, even 100 records performace is not optimum for your case.
> Please check the setup (configuration) and leakage of recourse if any.
> It should not go more than 8 seconds.
> But yup, it will highly depend on the content you updating.
>
> - regards
>
> Raj
> (+91-11-31261821)
>
> -----Original Message-----
> From: Shailender Jain [mailto:shailender.jain@teleatlas.com]
>
> Sent: Monday, July 26, 2004 12:26 PM
> To: Struts Users Mailing List
> Cc: struts-user@jakarta.apache.org
> Subject: Re: executeBatch
>
> Hi,
>
> I experimented this executeBatch with 13500  records.
>
> Here are the results
>
> Number of Records At one Time                         Time
> 100
> 20 Seconds
> 200
> 45 Seconds
> 500
> Application Hang
>
> The only Quesion here is why there is a optimium result for 100 records?
>
> Regards
> Shailender Jain
>
> tiwari.rajeev@wipro.com wrote:
>
> > Did you experiment breaking the batch to 2-3 packs? (500-800 in one
> go).
> >
> > - regards
> >
> > Raj
> > (+91-11-31261821)
> >
> > -----Original Message-----
> > From: Shailender Jain [mailto:shailender.jain@teleatlas.com]
> >
> > Sent: Monday, July 26, 2004 10:07 AM
> > To: struts-user@jakarta.apache.org
> > Subject: executeBatch
> >
> > Hi,
> >
> > I want to insert some 3000 records in the database.
> >
> > I  tried using executeBatch()  to insert all the records at a go.
> > But the application gets hang and nothing happens.
> >
> > When i try using PreparedStatement then it does work and just takes
> some
> > 30 seconds.
> > I am using Informix as the database and the DriverClass in
> ifxjdbc.jar.
> > I checked the specification of the driver
> > and it promises to be jdbc2.0  compliant.
> >
> > Any idea on how to improve the performance?
> >
> > Regards
> > Shailender Jain
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
> >
> > Confidentiality Notice
> >
> > The information contained in this electronic message and any
> attachments to this message are intended
> > for the exclusive use of the addressee(s) and may contain confidential
> or privileged information. If
> > you are not the intended recipient, please notify the sender at Wipro
> or Mailadmin@wipro.com immediately
> > and destroy all copies of this message and any attachments.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
>
> Confidentiality Notice
>
> The information contained in this electronic message and any attachments to this message
are intended
> for the exclusive use of the addressee(s) and may contain confidential or privileged
information. If
> you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com
immediately
> and destroy all copies of this message and any attachments.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message