Dear,

On Tue, 18 Nov 2003 09:21:23 -0000,
Alfred Seetoh wrote :

> Hi everyone,
> just wondering if anyone knows where I can see the FB 1.5
> performance benchmark against FB 1.0 and other databases? Recently I
> conducted a simple test, and the results were quite surprising.
>
> Previously I had created a FB 1.0 database. Then I installed FB 1.5,
> and created another database which is similar to the first one. I
> created a Delphi application using IBX components. This application
> will insert 10,000 records into each database. It turns out that
> inserting into FB 1.0 database is about 25% faster.
>
> Note: I'm using FB 1.5 engine in both tests.

Check the sync-writes status of both databases.
I suppose the one created with FB 1.0 has sync-writes disabled.
While the one created with FB 1.5 should have them.

It's better to have sync-writes enabled.

--
Best Regards,
Olivier Mascia
http://www.ibpp.org