| Subject | Re: [firebird-support] Re: Composite vs single column keys |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-08-26T21:18Z |
Steve Boyd wrote:
name ... SleepyCat for example. The suggestions about LIMIT/FIRST
may lead to other unpleasantness in Firebird because it has to
retrieve and sort the whole record set to find the first 100 unless
there's a single index with the same characteristics as the order
by clause.
Basically, if you're convinced that the only solution is a hammer -
as your programmers/bosses seem to believe - you'll be happier if
you make all problems be nails.
Cheers,
Ann
>>Maybe the right solution is to use an ISAM system with a more modern
> Doesn't matter. The point is that it needs to emulate ISAM file
> behaviour.
name ... SleepyCat for example. The suggestions about LIMIT/FIRST
may lead to other unpleasantness in Firebird because it has to
retrieve and sort the whole record set to find the first 100 unless
there's a single index with the same characteristics as the order
by clause.
Basically, if you're convinced that the only solution is a hammer -
as your programmers/bosses seem to believe - you'll be happier if
you make all problems be nails.
Cheers,
Ann