Opened 19 years ago
Closed 19 years ago
#2589 closed patch (fixed)
Extra index on program.manualid improves scheduler performance
Reported by: | Owned by: | stuartm | |
---|---|---|---|
Priority: | trivial | Milestone: | 0.21 |
Component: | mythtv | Version: | 0.20 |
Severity: | low | Keywords: | |
Cc: | Ticket locked: | no |
Description
Small patch to increase performance on the big scheduler query. A rather slow query is sped up significally by this:
DELETE FROM program WHERE manualid = -1 OR (manualid <> 0 AND -1 = -1);
Attachments (1)
Change History (3)
Changed 19 years ago by
Attachment: | program_index.diff added |
---|
comment:1 Changed 19 years ago by
Owner: | changed from Isaac Richards to stuartm |
---|
Note: See
TracTickets for help on using
tickets.
The sql patch..