RE: Java and Relations DBs..

["Hall, Philip" <phall@xxxxxxxx>]

> If you
> prepare the same query (select * from table where name = ?)
> then it will
> only prepare the statement once for that connection. The next time you
> execute that even if ? has a different value then it would not have to
> prepare it again.

But your mileage may vary, and greatly if you use 'insert into' as a
prepared statement.

On Windows2K using SQL7, individual insert into's where 10x *faster* than
using a prepared statement and I was just changing the data. I was testing
as we had records to add to the same table (about 20 odd fields) and in this
case a prepared statement was worse.

I finally implemented it using bulk loading, which is lightening fast...

108000 records
-  prepared statement takes about forever
-  individual inserts takes about 7 mins
-  bulk loading takes about just over a minute

--phil