[mythtv] Long scheduler runs

[Allan Stirling]

Mark Buechler wrote:
>> # Query_time: 11  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
>> DELETE FROM program WHERE manualid = -1 OR  (manualid <> 0 AND -1 = -1);


Since manualID is unsigned, this does not make any sense to me?

It is also the reason MySQL doesn't use the index - If you run:

mysql> select * FROM program WHERE (manualid <> 0 AND -1 =
-1) and manualid=-1;
Empty set, 1 warning (0.83 sec)

mysql> show warnings;
+---------+------+-------------------------------------------------------------+
| Level   | Code | Message
                   |
+---------+------+-------------------------------------------------------------+
| Warning | 1264 | Data truncated; out of range for column
'manualid' at row 1 |
+---------+------+-------------------------------------------------------------+
1 row in set (0.00 sec)



Cheers,

Allan.