Dear All,

Firebird 1.x is usually rather slow in returning the total row count for
a particular table/view/query. In a desktop (i.e. thick client)
applications, this is normally a non-issue for me, but i'm running into
a situation in web applications where this is a "must-have" feature.

I'm sure everyone is familiar with the need to show a "paged table" UI
where we need to show "page x of xx", "first page", "next page", etc, as
a navigator of some sort.

Considering that this view is going to be used most of the time, is
there any tricks to make firebird returns this information in a timely
manner? Barring that, maybe a safe and reliable way to 'cache' this
information ?

Thanks in advance,
regards,
sugi.