[mythtv] Housekeeping function thrashing mysql

[Chris Pinkham]

> I've logged a select sql which is causing mysql to jump to 100% for upwards
> of 40 seconds which kills anything else needing data. I believe the sql is
> part of the housekeeping thread. Is there anyway of putting a limit on the
> return and putting it in a loop instead of getting the whole thing at once?

This is the scheduler query:
 
> SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime,
> program.endtime, program.title, program.subtitle, program.description,
> channel.channum, channel.callsign, channel.name, oldrecorded.endtime IS NOT
> NULL AS oldrecduplicate, program.category, record.recpriority, record.dupin,

-- 
Chris