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