Thank you for the link to the archive. And sorry for posting the same
question again.

I hope that future version of firebird will come with better
performance for this Count() function. Will it on version 2.0 ?

On 6/1/05, Adam <s3057043@...> wrote:
> --- In firebird-support@yahoogroups.com, "Jonathan"
> <delphimania@g...>
> wrote:
> > Why is the "select count(*) from tablename" run slow in firebird ?
>
> Because Firebird uses multi-version records, the only way to know
> whether a record exists or not (in the context of your transaction) is
> to take a visit to the data page the record is located on. Non-multi-
> version records (is that even a word?) can just count the index or even
> faster store the record count for each table.
>
> >
> > Is there anyway to improve this ?
>
> Yes, just add a pinch of creativity. I have this stored in my bookmarks.
>
> http://groups.yahoo.com/group/firebird-support/message/56457
>
> Adam
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ________________________________
> Yahoo! Groups Links
>
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.