Subject Re: [Firebird-Java] Firebird as backing store for queue (was:Possible bug in ...)
Author Roman Rokytskyy
> Throughput with embedded engine under Jaybird: 1,000,000 messages in 960
> seconds. CPU was steady at 92% for the duration of the test.
>
> Improvement was 148 seconds, or 13%.
>
> I'll have to try with FB2 and Vulcan next, but that's a heavier duty set
> of system changes. I think I'll get the wire protocol sorted out first.

I would say that you have to check your code, for example check if you use
connection and prepared statement pooling, etc. Improvement of only 13%
means that in your system application is more busy doing different stuff,
but not with data persistence. It might be that your application is really
so busy, but run the profiler and check how much time application spends in
org.firebirdsql.* classes and especially which method of GDS_Impl class is
the most expensive - it should not be isc_dsql_prepare.

Roman