> Who needs a paginated view with 100.000 pages ?
>
> - Select min(date) and max(date) from your table
> - Present a nifty date selector to choose the records from any day,
> hour, minute, second
> - show them, with "next day" and "previous day" buttons
>
> - It's more useful to the user (most likely he wants to know what
> happened on 01/05/2005 rather than view page 2857)
> - It's faster (no more limit/offset ! just "date BETWEEN a AND b",
> indexed of course)
> - no more new items pushing old ones to the next page while you browse
> - you can pretend to your boss it's just like a paginated list
All very well and good, but now do it generically...