Need a lot more information.
Client and Server OS.
Server stats (memory, types and sizes of hard drives, etc)
Client applications written in what language, and what database objects
(BDE, IBO, etc)
What transaction isolation mode are you using


Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>

-----Original Message-----
From: david_vanc [mailto:david@...]
Sent: Friday, April 11, 2003 10:28 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Firebird performance is really poor


Hi, all. I am running some performance tests against Firebird, and to
be honest, it really stinks. For a single client I am getting only
around 10 TPS. I am sure I must be doing something wrong.

First, let me be clear, I don't want to do a test with write-through
turned off, because it is crucial that data is guaranteed to be there
if Firebird goes down. Writing to disk after a commit is not
acceptable for my application.

But the other thing that appears to be happening is with more than one
client, I immediately get deadlocks.

Is there a way to configure Firebird to improve its overall
performance without turning off write-through? Is there a way to get
rid of the deadlocks?

Thanks,

David



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=17051153
86:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>

<http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egroupmai
l/S=:HM/A=1457554/rand=668949135>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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