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...

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to