| Subject | Re: [firebird-support] Re: Limiting fetched rows doesn't offer much performance benefit |
|---|---|
| Author | Jason Dodson |
| Post date | 2006-03-08T21:51:27Z |
The reason for that is the time to run this is the time it takes to prepare the query, NOT fetch the records. The
preperation of these two will be the same, only what they fetch will be different.
Jason
jimbehr3446 wrote:
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
preperation of these two will be the same, only what they fetch will be different.
Jason
jimbehr3446 wrote:
> --- In firebird-support@yahoogroups.com, "Ivan Prenosil"--
> <Ivan.Prenosil@...> wrote:
>> Or are you saying that first command is not significantly faster
> than second one?
>> SELECT FIRST 50 * FROM TABLE WHERE FLAG='Y';
>> SELECT COUNT(*) FROM TABLE;
>>
> That is what we have observed.
>
> Thanks for your comments.
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.