Subject | Re: [Firebird-Java] Profiling... |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-05-24T06:40:39Z |
> I notice when doing many inserts, that the majority of time spent inI cannot tell this with 100% guarantee, but in my test cases it was ok.
> 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.
Reason is that for each execution wire protocol implementation must read the
response, so called status vector.
But if you wish, you can create a standalone test, I can have a look.
> I am using PreparedStatement#execute. Should I be usingPreparedStatement#execute is the right approach.
> 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.I cannot tell you for sure. You can also try version from HEAD. I have spent
> Anything I can do to minimize these reads?
quite some time optimizing the wire protocol there, maybe it is better than
JayBird 1.5.x.
Roman