Thanks for your help, here are the details

Wilson, Fred wrote:

> Need a lot more information.
> Client and Server OS.

Solaris 9 both. Client is running on separate machine from server

> Server stats (memory, types and sizes of hard drives, etc)

8 GB memory, gigabit ethernet, 72GB hard drive

> Client applications written in what language, and what database objects
> (BDE, IBO, etc)

Java, JDBC. I am running TPC-B. I don't know what you mean by
"database objects"

> What transaction isolation mode are you using

read uncommitted

>
>
> 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]
>
>
> *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/>.