in reply to Re: OT: peak values with SQL
in thread OT: peak values with SQL

Very nice explanation. I figured the subquery would not be ideal for large datasets, but this is a cool way to show why.

eclark++

Replies are listed 'Best First'.
Re^3: OT: peak values with SQL
by runrig (Abbot) on Jun 07, 2004 at 23:08 UTC
    I would create an index on uptime_id and re-run the comparison.
[reply]

In Section Seekers of Perl Wisdom