Martijn Tonies wrote:

> Ehm,
>
> > 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."
>
> What does that mean?

I mean that if the transactoin is committed, I expect the data to be
written to disk. Firebird has a mode where transactions are written to
disk after the commit, in a "lazy" fashion. This gives you
significantly better performance, but at the risk of losing committed data.

>
> > 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?
>
> It depends - deadlocks are your friend, not your enemy.

My problem here is that when I run exactly the same test on either MySQL
or Pointbase I get exactly zero deadlocks. So why is Firebird giving me
deadlocks when nobody else is?

>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com
>
> See you at the First European Firebird Conference in May in Fulda, Germany
> http://www.firebird-conference.com
>
> *Yahoo! Groups Sponsor*
> <http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=1705115386:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3083889&prop=egroupweb&pos=HM>
>
>
>
> 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/>.