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
