From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: PFC <lists@boutiquenumerique.com>
Cc: aurora <aurora00@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: browsing table with 2 million records
Date: Thu, 27 Oct 2005 09:46:14 +0800
Message-ID: <43603166.40705@familyhealth.com.au> (raw)
In-Reply-To: <op.sy9v9gketh1vuj@localhost>
References: <cbd177510510261341l4ed7a214lda9d67af12f2ec21@mail.gmail.com>
<op.sy9v9gketh1vuj@localhost>
> 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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: chriskl@familyhealth.com.au, lists@boutiquenumerique.com, aurora00@gmail.com
Subject: Re: browsing table with 2 million records
In-Reply-To: <43603166.40705@familyhealth.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox