Subject Re: [firebird-support] I can't believe Firebird's record count is not optimized...
Author Michael Weissenbacher
>> Im so dissapointed.
> Go back to MySQL and forget about Firebird as a nightmare.
In fact it's exactly the same when using the InnoDB Engine in MySQL (which is
the only working TRANSACTIONAL engine available for it). It's also exactly the
same with postgresql. To sum it up, NEVER do full-table scans with count(*) in
a REAL database unless you have a very good reason for it (or the table is tiny).