Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#11282 closed Patch - Bug Fix (fixed)

Marking episode first/last performance improvement when no programid is available

Reported by: mv02@… Owned by: Karl Egly
Priority: major Milestone: 0.27
Component: MythTV - Mythfilldatabase Version: 0.26-fixes
Severity: low Keywords: mythfilldatabase performance database schema
Cc: Ticket locked: no


The patch introduced in Ticket #10482 greatly improves performance for program entries which have a programid. However on my system with lots of entries without a programid (~73000, provider epgdata for Germany) episode marking now takes around 20 minutes. During this time, MySQL is consuming one CPU core completely, but not doing much I/O.

Adding an additional INDEX for columns starttime, title and subtitle improved the performance dramatically, now episode marking is done in about 10 seconds.

Attachments (2)

0018-add-index-to-improve-mythfilldatabase-performance.patch (1.4 KB) - added by Karl Egly 8 years ago.
0016-add-index-to-improve-mythfilldatabase-performance.patch (3.4 KB) - added by Karl Egly 8 years ago.
revised patch

Download all attachments as: .zip

Change History (8)

comment:1 Changed 8 years ago by Karl Egly

Owner: changed from stuartm to Karl Egly
Status: newassigned

Changed 8 years ago by Karl Egly

comment:2 Changed 8 years ago by m.a.zulliger@…

I confirm that the patch improves the performance drastically (from ~20min to 15s in my case) after adapting it to mythtv-0.26.0+fixes.20130721.99eb39a. Thank you!

comment:3 Changed 8 years ago by stuartm

Milestone: unknown0.27
Priority: minormajor
Type: Patch - FeaturePatch - Bug Fix

comment:4 Changed 8 years ago by Karl Egly


Changed 8 years ago by Karl Egly

revised patch

comment:5 Changed 8 years ago by Karl Dietz <dekarl@…>

Resolution: fixed
Status: assignedclosed

In 8acb5adf90cbe41c3de1c3084752aa70fbf52308/mythtv:

add index to improve mythfilldatabase performance

fix index documentation of related index while here

slipping it in before the beta is cut as per discussion at

Fixes #11282

comment:6 Changed 8 years ago by Stuart Auchterlonie

Note: See TracTickets for help on using tickets.