Re: Table Sorting and Limit Question

--- Dawn Hollingsworth <dmh(at)airdefense(dot)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