Opened 17 years ago
Closed 17 years ago
#2988 closed enhancement (fixed)
database index updates
Reported by: | xris | Owned by: | Isaac Richards |
---|---|---|---|
Priority: | minor | Milestone: | 0.21 |
Component: | mythtv | Version: | head |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description (last modified by )
Been watching the slow and no-touch-index query log and have some up with some additional indexes that should help out somewhat. Unfortunately, none of the queries that pointed these out is called often enough to make a significant improvement, but it's always good to be more efficient.
I still have the affected queries if you would like to see them. Some are rather large, so I opted to leave them out of the ticket.
see attached diff.
Attachments (1)
Change History (4)
Changed 17 years ago by
Attachment: | dbcheck.diff added |
---|
comment:2 Changed 17 years ago by
Milestone: | unknown → 0.21 |
---|---|
Version: | 0.20 → head |
Note: See
TracTickets for help on using
tickets.
just need to verify that the code is clean and I'm doing things correctly.