"buppcpp" <buppcpp@...> wrote:

>
> Your main focus is just to gather more information to try to bash me
> with instead of focusing on the problem.

There are "by design" problems that are unlikely to be solved. Telling us
the other DBMS is letting us know the features it supports. As it was
already told, index-only scans are supported by a lot of DBMS, but this is
impossible in FB. Using index for DISTINCT allows you to quickly fetch the
first rows, but FB doesn't do that. So you may experience some issues anyway
and you should be prepared to deal with them. IMHO, this is nonsense to
require that you could move from database A to database B (provided thay're
very different) without changing a line in your application and get the same
or better overall performance. Dumb database comparison never works in the
real life.

Nobody wants to bash you. I know that e.g. Oracle outperforms us in many
areas. We could improve in some of them and cannot in others. But at least I
know what Oracle can do and hence whether our improvements are possible or
not. With the black box you provide, I cannot even guess what could be
wrong.

And anyway, forget about having your issues fixed in v2.0, this is
practically impossible. Sorry for disappointing you.


Dmitry