|
|
Posted by Andy Hassall on 06/29/05 00:10
On 28 Jun 2005 13:53:45 -0700, "frizzle" <phpfrizzle@gmail.com> wrote:
>Hmm, i've thought of your second option,
What second option? Please quote some context when replying.
>but i wondered if i could change things closer
>to the information's root ...
>The Mysql version is recent, but i don't know
>what you mean with subquery.
select id
from (
select id
from t
order by t desc
limit 5
)
order by id
>I also figured i could get the total possible results,
>substract number of uploaded pictures, and then
>use that as the offset within Limit.
>Or would that make things slow (in quite a small db)
Possibly. Try it. I'm more used to Oracle where you'd do this differently, so
can't comment too much on optimising usage LIMIT in MySQL.
--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Navigation:
[Reply to this message]
|