Svein Erling Tysvær wrote:

> time out on our network). Except from this case, I don't share your
> experience with Firebird queries being slow - be it joined queries or
> correlated subqueries (though, of course, I sometimes change the query
> after inspecting the plan).

Well, I suppose that as usual MS creates product for "dummy users" who
don't really know what they're doing, and so have created a DB server
that performs acceptably (almost) no matter what the user asks for.

In contrast, perhaps Firebird requires you to be more aware of how the
optimizer works and to know how to read and modify query plans. If you
obtain those skills, maybe Firebird in general performs better than SQL
Server (I wouldn't know).

The contrast is that, to me, it seems that the performance contrast
between "best written query" and "worst written query" is much larger in
FB than in SQL Server. For me personally, that's a problem because I'm a
RAD kind of person in that I tend to
write-test-modify-test-modify-...-done. With SQL Server I usually need
only one iteration but with Firebird I more often need a few iterations
to get decent query performance.

Again, havnt' gained enough 2.1 experience yet to be able to say if it's
better now.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64