struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <tiwari.raj...@wipro.com>
Subject RE: executeBatch
Date Mon, 26 Jul 2004 04:43:30 GMT

Wow giri,
Same reply

- regards

Raj
(tiwari.rajeev@wipro.com)
(+91-11-31261821)

-----Original Message-----
From: Giri Senji [mailto:girisenji@gmail.com]
Sent: Monday, July 26, 2004 10:10 AM
To: Struts Users Mailing List
Subject: Re: executeBatch

Why not break it into 30 requests of executeBatch( with 100 records each
time)

On Mon, 26 Jul 2004 10:06:43 +0530, Shailender Jain
<shailender.jain@teleatlas.com> wrote:
> 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
>
>


--
Giri SENji
248-425-9915

---------------------------------------------------------------------
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
View raw message