Opened 19 years ago

Closed 19 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 xris)

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)

dbcheck.diff​ (1.5 KB ) - added by xris 19 years ago.
just need to verify that the code is clean and I'm doing things correctly.

Download all attachments as: .zip

Change History (4)

by xris, 19 years ago

Attachment: dbcheck.diff​ added

just need to verify that the code is clean and I'm doing things correctly.

comment:1 by xris, 19 years ago

Description: modified (diff)

comment:2 by xris, 19 years ago

Milestone: unknown → 0.21
Version: 0.20 → head

comment:3 by xris, 19 years ago

Resolution: → fixed
Status: new → closed

(In [12666]) closes #2988. Apply all of my db index changes. This seems to compile/apply fine with no errors, so I'm just going to let it go through.

Note: See TracTickets for help on using tickets.