Subject | RE: [firebird-support] Interbase 6.0.1.6 |
---|---|
Author | Robert Gilland |
Post date | 2004-01-28T22:05:12Z |
1. Can we run a firebird install( does it exist) straight over the top of a
currently installed IB 6.0.1.6?
2. More specifics.
With IB we found that an SQL
Select *
from ATABLE
where
( AField IN ( Select BField from anothersmalltable ))
took 10 minutes
where
select *
from ATABLE
where
( AField = 'AValue' )
run multiple times and appended to a clientdataset took 5 seconds.
I am perplexed and troubled by this discrepancy.
Regards,
Robert.
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, 28 January 2004 5:04 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Interbase 6.0.1.6
At 01:13 AM 28/01/2004 +0000, you wrote:
aren't in IB 6.0.1.6 plus another year's backporting of fixes and
enhancements from Firebird 1.5 development.
Firebird 1.5: more bug-fixes, more language enhancements, optimizer speed
enchancements.
See the respective release notes for these versions for details.
interbase is usually due to poorly performing queries, neglect of
housekeeping and writing applications that are not careful about
optimising
cleanup of garbage. You can write applications like that in Firebird, as
well.
Try posting an explicit question about a situation that seems slow for
your
setup. Vague questions like "Why is interbase (or firebird) slow?" are
about as useful as "When did you stop beating your wife?"
/hb
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
currently installed IB 6.0.1.6?
2. More specifics.
With IB we found that an SQL
Select *
from ATABLE
where
( AField IN ( Select BField from anothersmalltable ))
took 10 minutes
where
select *
from ATABLE
where
( AField = 'AValue' )
run multiple times and appended to a clientdataset took 5 seconds.
I am perplexed and troubled by this discrepancy.
Regards,
Robert.
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, 28 January 2004 5:04 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Interbase 6.0.1.6
At 01:13 AM 28/01/2004 +0000, you wrote:
>We use Interbase 6.0.1.6 off the mers.comFirebird 1.0.3: two years of bug-fixes and language enhancements that
>site.
>What advantages would there be for us to
>move to firebird?
aren't in IB 6.0.1.6 plus another year's backporting of fixes and
enhancements from Firebird 1.5 development.
Firebird 1.5: more bug-fixes, more language enhancements, optimizer speed
enchancements.
See the respective release notes for these versions for details.
>We are finding a major problem in speed ofGood question. Interbase isn't slow. Firebird isn't slow. Slowness in
>interbase.
>Can firebird help.
interbase is usually due to poorly performing queries, neglect of
housekeeping and writing applications that are not careful about
optimising
cleanup of garbage. You can write applications like that in Firebird, as
well.
Try posting an explicit question about a situation that seems slow for
your
setup. Vague questions like "Why is interbase (or firebird) slow?" are
about as useful as "When did you stop beating your wife?"
/hb
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]