Subject Re: [firebird-support] Firebird/Internet performance questions
Author David Johnson
How many rows per transaction?
----- Original Message -----
From: Andrew Gough
Sent: Thursday, January 15, 2004 2:33 PM
Subject: Re: [firebird-support] Firebird/Internet performance questions

Hi David,

----- 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.
> 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.


Andrew Gough
LiveNote Technologies Inc.

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]