Also importantly, "java.util.Date" is not recommended.
Why not just choose to use "System.currentTimeMillis()" ?
----------------------------------------
Romantic Emotionalists Must Endure Ordeals.
Email1(200103): [EMAIL PROTECTED]
Email2(200011): [EMAIL PROTECTED]
Email3(199908): [EMAIL PROTECTED]
Email4(199906): [EMAIL PROTECTED]
Office: Tokyo, Japan http://www.gecapital.com
Home: Dalian, Liaoning, China (Hometown: Hunan)
----------------------------------------
-----Original Message-----
From: Martin Cooper [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 5:10 PM
To: [EMAIL PROTECTED]
Subject: Re: Type1 driver vs Type4 driver
If you're trying to measure performance, why in the world would you have
System.out.println() calls in your code???
--
Martin Cooper
----- Original Message -----
From: "Arun Jayaprakash" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 3:09 AM
Subject: Type1 driver vs Type4 driver
> Hi,
>
> I have a strange problem while using the JDBC drivers. I
> connected to an Oracle database using the ODBC bridge,
> wrote 10000 records into a table. It took around 13 seconds
> (auto-commit was set off). When I repeated the same code
> with a Oracle-JDBC driver, it took around 10 seconds!!
> Surely the Oracle-JDBC driver should have taken less time.
>
> I am enclosing the code. Can anybody tell me where I could
> have gone wrong?
>
> ---------Code begins here-----------------
> import java.sql.*;
> public class DBTest
> {
> private long lngDif;
> private java.util.Date dtStart,dtStop;
> private Connection conOra;
> private PreparedStatement pst;
>
> public DBTest()
> {
> try
> {
>
> Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
>
> conOra =
>
DriverManager.getConnection("jdbc:oracle:thin:@infotech:1521:infotech","scot
t","tiger");
> conOra.setAutoCommit(false);
>
> pst = conOra.prepareStatement("insert into Test
> values(?,?)");
>
> dtStart = new java.util.Date();
> System.out.println(dtStart);
> for (int a=0; a<9999; a++)
> {
> pst.setInt(1,a);
> pst.setString(2,String.valueOf(a));
> pst.executeUpdate();
> }
>
> dtStop = new java.util.Date();
> lngDif = dtStop.getTime() - dtStart.getTime();
> System.out.println("Difference in time in Oracle is
> "+lngDif/1000+" seconds");
> }
> catch(Exception se)
> {
> System.out.println(se);
> }
> }
>
> public static void main(String args[])
> {
> DBTest dbt = new DBTest();
> }
> }
>
> ---------Code ends here-----------------
>
> Thanks and bye,
> Arun Jayaprakash.
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
