Subject RE: [firebird-support] Performance of the count Function.
Author Nigel Weeks
> And yes Nigel, I need the count. Need it for a result set
> like Google.
> Always wondered how they do it. But that's probably way of
> topic here. I
> suspect they set up their tables and indices totally
> different then I, a
> mere mortal, am doing.

Have you noticed that google's pages bar often just shows 10 pages?
And how, if you start going through them, they either expand out to more
pages, or stop at 5 with a "If you want to see results similar to those
already displayed, click here" message.

Could you simply show 5 pages at the start?
If you go past the 5th page, and the record fetch returned more rows,
display links for 6-10 pages.
If you get to the 3rd page, and run short of records, don't display the
links for the next few...

Just an idea. It might not suit your requirements, but it might be close.
:-)

N