Subject Query Performance - correlated subqueries and group by statements
Author Aaron Abend
I am using Firebird and have found that correlated subqueries and queries
involving group by statements are unusually slow (compared to MS SQL

I have indexed the tables in what I believe is an appropriate way, based on
experience in SQL Server and Oracle. Are Firebird index strategies
significanty different?

I also notice that Firebird is not using much memory, which is good, I
guess, but at a certain point I'd rather let it eat more memory and run
faster. It's using only 20 mb of memory right now and going fairly slow on
these subquery and group by statements.

In Oracle, for example, I can allocate more database buffers to improve
performance. Is there a similar concept in Firebird?

Any ideas?



Yahoo! Groups Links