> what were the config changes? how much memory is too much from your
> judgement? or do you mean more than PG?

Firebird was trying to use more memory than was available to it.
I made no changes to PG.

> then you need to conclude what you will from this. But I would

still say

> that even with superior performance on these queries from PG, I

would not

> design my system to use these queries. I would skin the cat a

completely

> different way and I would get the same result in less than a

second.

> Evenqueries which run for 30 seconds is totally unacceptable to

me. I prefer

> subsecond results but you cannot get this with a demand to scan 2

million

> records.
> Alan

I don't have the liberty to change code just to fit Firebird.
The application has developers around the country, all doing their
part. Also the application will be designed to work with different
databases.

More and more applications are starting to go the route of multiple
databases, because it has the benefit of making a better fit for the
customer, increase profits (with the use of Open Source DB's) and
expand your customer base.

So since our current application is written in accordance with SQL
standards in mind and our current database can handle these queries
just fine (just can't handle many users) I think it would be
unproductive for us to make such changes because a database can't
perform well using normal SQL.

The change should be to fix the database so that not only will I
benefit from it, so will you and every other new developer to FB.