OK just to cause a bit more trouble, that query there we're playing with is bringing back and entire MONTH of data, which is HUGE. So every time the database is creating that query it's working with gobs of data, while all it wants is the last 10 entries, which happened within the last hour.
Can I at least change this so it only works with the last day? Surely that would speed up the query vastly, and not unnecessarily bring in the other 29 solid days worth of data in the results set.
Is this query used for anything else besides that "recent posts" island?
