Subject | Re: [ib-support] Re: Firebird performance |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-02-24T11:56:53Z |
At 10:03 24.02.2003 +0000, you wrote:
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.
Set
- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
> > > use, but also periodically updating 100.000 records or more, orJust to balance that a bit. I work together with Aage and if things are
> exporting a
> > > million records with hardly perceptible impact for other users.
>Wow, that sounds good! ;)
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.
Set
- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation