On Feb 24, 2006, at 23:13 , jcfischer wrote:
> Is there a way to limit the expensive query to only those last 1000
> (or
> whatever) results?
>
> I have tried to nest SELECTS but my SQL-fu is to limited to get
> anything through the SQL processor :-)
The basics of a subquery are:
SELECT <expensive query>
FROM (
SELECT *
FROM table
ORDER eventtime DESC
LIMIT 1000
) as most_recent_1000
Don't know enough about the other parts, but hopefully this can get
you started. :)
Michael Glaesemann
grzm myrealbox com