I was under the impression, for example, that the Query optimiser
had been improved after v4.

I'm trying to 'sell' moving to FB and the best thing I can say is
something like "we could expect an average 50% improvement over v4 speed".

>From: Paul Reeves <paul@...>
>Reply-To: ib-support@yahoogroups.com
>To: ib-support@yahoogroups.com
>Subject: Re: [ib-support] IB4 vs FB speed
>Date: Tue, 08 Jan 2002 11:43:00 +0100
>
>Nick Upson wrote:
> >
> > Can anyone give me a rough idea of the performance improvement
> > I could reasonably expect if I move from IB4 to Firebird to help
> > me justify making that move.
> >
>
>Reasonably expect? Probably Zero. A lot depends upon the database design
>and
>the uses to which it is put.
>
>Areas which have seen improvement are:
>
> SuperServer architecture available on all platforms
>
> o this has improved caching for multiple connections,
> o zero lock file contention as everything is controlled by a
> single process.
>
>
> Sweeping and Garbage collection are less intrusive. I'm not sure how
> classic behaves in this respect but under SuperServer sweep and GC are
> low priority threads. GC is no longer done by active user connections.
>
>
>There are probably other areas where performance has been improved, but
>nothing springs immediately to mind, and its a long time since I used v4.
>
>Maybe it would be better to re-phrase the question? There are lots of good
>reasons to move to Firebird and in some cases performance is one of them
>but
>it does depend on what your application is doing.
>
>
>Paul
>
>--
>
>Paul Reeves
>http://www.ibphoenix.com
>taking InterBase further
>

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com