Subject Re: [ib-support] Re: Firebird performance
Author Svein Erling Tysvaer
At 10:03 24.02.2003 +0000, you wrote:
> > > use, but also periodically updating 100.000 records or more, or
> exporting a
> > > million records with hardly perceptible impact for other users.
>Wow, that sounds good! ;)

Just to balance that a bit. I work together with Aage and if things are
done correctly, then sure, things like this doesn't affect other users. But
we do run quite a few ad-hoc queries as well, and do have to be careful to
check the plans before running them. Executing queries carelessly can
easily bring the system to a halt, at least that is what it feels like when
the wrong query is executed (e.g. doing a SELECT ... WHERE <field> in
(SELECT ...) guarantees problems on tables with over a million rows).
Though the general impression that your system should be no match for
Firebird is certainly valid. Hopefully someone can tell you how to add
users from VB.


- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at