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" [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > > Sent: Monday, July 26, 2004 12:26 PM > To: Struts Users Mailing List > Cc: [EMAIL PROTECTED] > 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 > > [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > > > > Sent: Monday, July 26, 2004 10:07 AM > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > 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 [EMAIL PROTECTED] immediately > > and destroy all copies of this message and any attachments. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > 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 [EMAIL > PROTECTED] immediately > and destroy all copies of this message and any attachments. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]
