----- Original Message -----
From: "David Johnson" <d_johnson@...>
Sent: Thursday, January 15, 2004 1:06 PM


>
> So I can only expect 68 transaction per second or roughly 250,000
transactions per hour (I agree, row count is beside the point)? I will run
a recalibrated test to see how far this gets me.
>
[snip...]
>
> Since the typical insert transaction in my framework will be in the
neighborhood of ten statements, I will work with this. I will also prepare
a test case for random accesses through the database.
>
> Any other sggestions you have would be appreciated.

When we started working with Firebird, we also had issues with insert
performance. A complex set of insertions across multiple individual tables
using individual SQL statements prepared & executed across the network was
taking upwards of 15 minutes.

The same functionality placed in a parameterised stored procedure performed
_exactly_ the same operation in < 1 sec.

If you can commit to a DBMS platform (ie. Firebird), there are huge
performance gains you can achieve using specific features at the cost of
DBMS portability.

HTH,

Andrew Gough
LiveNote Technologies Inc.