Skip site navigation (1) Skip section navigation (2)

Re: Slow count(*) again...

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

pgsql-performance by date

Next:From: Mladen GogalaDate: 2010-10-12 14:04:18
Subject: Re: Slow count(*) again...
Previous:From: Tom LaneDate: 2010-10-12 13:56:30
Subject: Re: Slow count(*) again...

pgsql-hackers by date

Next:From: Mladen GogalaDate: 2010-10-12 14:04:18
Subject: Re: Slow count(*) again...
Previous:From: Tom LaneDate: 2010-10-12 13:56:30
Subject: Re: Slow count(*) again...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group