Thursday, November 15, 2001
More time studies today using JDBC to move records from MS Access to Oracle. With an Oracle Insert taking 25 msecs and the XML creation taking 1 msec, each object starts out taking 26 msecs. When the whole program (reading records, starting threads, database connections, etc.) was run, each object took 149 msecs to process. After I adding a database connection pool, each object took 109 msecs. Which is still too long. My goal is 36 msecs to process 100,000 objects per hour.