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 10:02:03 GMT

I am perfectly in sync with Matthew.
For shailendar's problem, I am looking into the format in which batch
request goes to database so that we could limit the number of characters
of this is issue.


- regards

Raj
(+91-11-31261821)

-----Original Message-----
From: Matthew Ryan [mailto:matthew@matthewryan.info]
Sent: Monday, July 26, 2004 2:42 PM
To: Struts Users Mailing List
Subject: RE: executeBatch

I had to insert 1,300,000 records the other day in one hit. first I used
Statements, then PreparedStatements, both took time.

Then I just used piped the files in from the shell. The difference was
unbelievable. Do you have to use Java?

If it is a one-time, hit and run, get them in there, then you might
consider
going straight to the shell. In my case it was a change over of systems
with
a dump of one to go straight into the other. A one time deal.

Otherwise, best of luck.


Matthew


-----Original Message-----
From: Shailender Jain [mailto:shailender.jain@teleatlas.com]
Sent: Monday, 26 July 2004 2:37 PM
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


---------------------------------------------------------------------
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