-
From: Shailender Jain [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 6:48 PM
To: Struts Users Mailing List
Subject: Re: executeBatch
for (CONDITION) {insert into }
Amit Kumar Sharma wrote:
> Dear Shailender,
>
> What type of insert are you trying to do, is it a single insert(eg:
Toomuchnoise.
"Shailender Jain"
<[EMAIL PROTECTED]>
07/26/2004 09:18 AM
Please respond to
"Struts Users Mailing List" <[EMAIL PROTECTED]>
To
Struts Users Mailing List
<[EMAIL PROTECTED]>
cc
Subject
Re: executeBatch
for
for (CONDITION) {insert into }
Amit Kumar Sharma wrote:
> Dear Shailender,
>
> What type of insert are you trying to do, is it a single insert(eg:
> Insert into (select * from *)) or multiple insert (eg
> for(CONDITION){insert into})
>
> Regards
> Amit
>
> -Original Message-
> From: Shail
Dear Shailender,
What type of insert are you trying to do, is it a single insert(eg:
Insert into (select * from *)) or multiple insert (eg
for(CONDITION){insert into})
Regards
Amit
-Original Message-
From: Shailender Jain [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 10:07 AM
T
Have you written a Stored Procedure on the database to handle your batch.
You can send an array containing all the values you need to insert/update
via the batch.
It will help you to cut down / lower execution time significantly, i.e.,
improve performance.
You can also try to pass the array of val
What is the problem with your current performance?
-Original Message-
From: Shailender Jain [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 6:37 AM
To: [EMAIL PROTECTED]
Subject: executeBatch
Hi,
I want to insert some 3000 records in the database.
I tried using executeBatch() t
You should try a DB list, maybe informix DB list, this is a Struts list.
.V
[EMAIL PROTECTED] wrote:
-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
EMAIL PROTECTED]
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 differenc
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
in the \tomcat\log\localhost-DATE.log file.
>
> -Original Message-
> From: Shailender Jain [mailto:[EMAIL PROTECTED]
>
> Sent: Monday, July 26, 2004 12:36 PM
> To: Struts Users Mailing List
> Cc: [EMAIL PROTECTED]
> Subject: Re: executeBatch
>
> Where does the log
: [EMAIL PROTECTED]
Subject: Re: executeBatch
Where does the log gets generated.
I am using Struts with Tomcat 5.0.16.
Is there any configuration which i need to change so that some log gets generated. I
checked the catalina.out generated by Tomcat but there was nothing i could see there.
[EMAIL
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: exec
say ??
>
> Can you give us the log output ?
>
> Regds
> r-a-v-i
>
> -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: ex
)
-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
Wot does log say ??
Can you give us the log output ?
Regds
r-a-v-i
-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
Hi,
I experimented this executeBatch with 13500 records.
Here are the results
Number of Records At one Time Time
100 20 Seconds
200
Wow giri,
Same reply
- regards
Raj
([EMAIL PROTECTED])
(+91-11-31261821)
-Original Message-
From: Giri Senji [mailto:[EMAIL PROTECTED]
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
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
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
<[EMAIL PROTECTED]> 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
19 matches
Mail list logo
