Re: Table Sorting and Limit Question

--- 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