Dave,

> I am in the process of upgrading from Interbase 6.0.1 to Firebird

1.5.2

> and
> I am seeing a substantial performance hit in our application. I put
> together a small performance test to compare raw SQL performance of

both

> databases inserting, querying and updating a simple table to help
> quantity /
> resolve the problem. As far as I can tell, it looks like Firebird is
> running at less than half the speed of Interbase OOTB....

Are you aware that Firebird by default creates all database on Win32
platforms with ForcedWrite set to ON (safe setting) but Interbase sets
it to OFF (dangerous setting)?

Further, have you ensured that the Cache pages config value is the same
for both installs?

These could account for the performance difference you are seeing.


Sean