Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id F3AE94754A4
	for <pgsql-sql@postgresql.org>; Thu,  8 Aug 2002 21:42:19 -0400 (EDT)
Received: from web40009.mail.yahoo.com (web40009.mail.yahoo.com
 [66.218.78.27])
	by postgresql.org (Postfix) with SMTP id 4A43D47546C
	for <pgsql-sql@postgresql.org>; Thu,  8 Aug 2002 21:42:19 -0400 (EDT)
Message-ID: <20020809014223.3100.qmail@web40009.mail.yahoo.com>
Received: from [202.163.208.14] by web40009.mail.yahoo.com via HTTP;
	Thu, 08 Aug 2002 18:42:23 PDT
Date: Thu, 8 Aug 2002 18:42:23 -0700 (PDT)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: Re: Table Sorting and Limit Question
To: Dawn Hollingsworth <dmh@airdefense.net>
Cc: PosgreSQL Mailing List <pgsql-sql@postgresql.org>
In-Reply-To: <1028837453.4754.1.camel@kaos>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/157
X-Sequence-Number: 9003


--- Dawn Hollingsworth <dmh@airdefense.net> wrote:
> 
> 
> Currently we have a table with a sequence number( id
> ) as a primary key,
> a date field which is indexed and several other
> columns. The user
> interface allows the user to sort the data by date
> and limits the result
> set to 100 rows. 
> 
> The question is: 
> The user interface needs the capability to sort the
> table by date but
> pull out the hundred row set that contains id
> say...542 for example. 
> 
> What would be the best way to do this taking into
> account this table is
> several hundred thousand rows? 

try also to index the id.

Try :
Select *
from <table>
where id=<id>
order by date
limit <limit no>

In this case you <limit no> is 100 since you want to
return at most 100 rows.

hope that helps.

ludwig.


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com