Subject | prepared insert |
---|---|
Author | pmoon7@yahoo.com |
Post date | 2001-06-01T19:17:22Z |
System.gc();
prepStmtInsert = genSql.setPrepStmtValue(prepStmtInsert, fileRow);
for (int cc=0; cc<100; cc++)
{
int intXX = prepStmtInsert.executeUpdate();
}
I wrote the above preparedStatement in java to insert 100 records into
IB5.6. It took 250 seconds to update. In MS Access using OBDC, the
same insert of 100 records took 80 seconds. Index was turned off and
I am using JDBC to IB5.6, seems like it should beat MS Access. I must
be doing something wrong. Appreciate any help...thanks
prepStmtInsert = genSql.setPrepStmtValue(prepStmtInsert, fileRow);
for (int cc=0; cc<100; cc++)
{
int intXX = prepStmtInsert.executeUpdate();
}
I wrote the above preparedStatement in java to insert 100 records into
IB5.6. It took 250 seconds to update. In MS Access using OBDC, the
same insert of 100 records took 80 seconds. Index was turned off and
I am using JDBC to IB5.6, seems like it should beat MS Access. I must
be doing something wrong. Appreciate any help...thanks