Subject | Profiling... |
---|---|
Author | robert_difalco |
Post date | 2005-05-23T23:38:22Z |
I notice when doing many inserts, that the majority of time spent in
my application is in org.firebirdsql.gds.XdrInputStream.read and
org.firebirdsql.gds.XdrInputStream.readInt. Even more time is spent
here than in org.firebirdsql.gds.XdrOutputSTream.write( ... ), which
seems odd since these are all insert executions with prepared statements.
I am using PreparedStatement#execute. Should I be using
PreparedStatement#executeUpdate instead? I thought the later would be
even slower since it needed to lookup the update count. Those from
#execute take even longer than my openOrCreateBlob calls. Anything I
can do to minimize these reads?
TIA.
R.
my application is in org.firebirdsql.gds.XdrInputStream.read and
org.firebirdsql.gds.XdrInputStream.readInt. Even more time is spent
here than in org.firebirdsql.gds.XdrOutputSTream.write( ... ), which
seems odd since these are all insert executions with prepared statements.
I am using PreparedStatement#execute. Should I be using
PreparedStatement#executeUpdate instead? I thought the later would be
even slower since it needed to lookup the update count. Those from
#execute take even longer than my openOrCreateBlob calls. Anything I
can do to minimize these reads?
TIA.
R.