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:

>We use Interbase 6.0.1.6 off the mers.com
>site.
>What advantages would there be for us to
>move to firebird?

Firebird 1.0.3: two years of bug-fixes and language enhancements that
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 of
>interbase.
>Can firebird help.

Good question. Interbase isn't slow. Firebird isn't slow. Slowness in
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]