Subject | RE: [firebird-support] Performance of the count Function. |
---|---|
Author | Nigel Weeks |
Post date | 2005-03-01T02:53:07Z |
> And yes Nigel, I need the count. Need it for a result setHave you noticed that google's pages bar often just shows 10 pages?
> 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.
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