Subject RE: [firebird-support] using multiple databases
Author Fabricio Araujo
As Ann Harrison pointed, vulcanizing the engine
must be finished before any of that things could be
resolved or planned.

Have you saw the end of FB-Architecture discussion
about transient datasets? It's cool and can wait
good things about it as a advangeful replacement
(for majoritiy of SP use) for temp tables. Just amazing.

BUT I'll not let this subject fall forgotten... With such
a feature (and transient datasets) we can throw MSSQL 2k
to the trashcan with no conscience weight... ;-)

There were the same opposition with dynamic sql
and we have EXECUTE STATEMENT now...

Resistance is a good thing: make us thinking
in sharper arguments. ;-)

>However, it is also true that many others have express their interest and
>support in this particular subject.
>
>I am of the opinion that such a feature would greatly enhance FB and benefit
>many of its users. But most importantly, take FB one step further in its
>evolution as a superb DB. Thus, my total lack of understanding regarding the
>" opposition and criticism "

Man, this feature would take us a step front of M$ crap server.
If it gets available before MSSQL2005, much better. A open source
with multidb server side SQL queries and sps (the "server side" is to
make precise that I'm not talking about distributed client
transactions) -
and much more robust than MSSQL... WOW!!!

This will take us to a step back to the degree of respect
that Oracle worshipers take from their db. On engine real useful
features
FB will stand only before Oracle on the enterprise level server arena.