ok. you are asking how i calculated the Time. I calculated the results using the System.out.println(new java.util.Date());
This i picked from logs only. [EMAIL PROTECTED] wrote: > If you can write some debug information in to the logs [use system.out.println], it > will create log 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 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 PROTECTED] wrote: > > > 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 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] > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
