----- Original Message -----
From: Andrew Gough
To: firebird-support@yahoogroups.com
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.
>
[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.




------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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



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