From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Neil Whelchel" <neil(dot)whelchel(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Slow count(*) again... |
Date: | 2010-10-12 13:56:33 |
Message-ID: | 4CB422C102000025000367F7@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com> wrote:
> What is the best method to make a page of results and a list of
> links to other pages of results?
For our most heavily used web app we decided to have the renderer
just read the list of cases and render the pages to disk, and then
present the first one. We set a limit of 500 entries on the list;
if we get past 500 we put up a page telling them to refine their
search criteria. That won't work for all circumstances, but it
works well for out web app.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2010-10-12 14:04:18 | Re: Slow count(*) again... |
Previous Message | Tom Lane | 2010-10-12 13:56:30 | Re: Slow count(*) again... |
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2010-10-12 14:04:18 | Re: Slow count(*) again... |
Previous Message | Tom Lane | 2010-10-12 13:56:30 | Re: Slow count(*) again... |