Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#11282 closed Patch - Bug Fix (fixed)

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

Reported by: mv02@… Owned by: dekarl
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 dekarl 5 years ago.
0016-add-index-to-improve-mythfilldatabase-performance.patch (3.4 KB) - added by dekarl 5 years ago.
revised patch

Download all attachments as: .zip

Change History (8)

comment:1 Changed 5 years ago by dekarl

  • Owner changed from stuartm to dekarl
  • Status changed from new to assigned

Changed 5 years ago by dekarl

comment:2 Changed 5 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 5 years ago by stuartm

  • Milestone changed from unknown to 0.27
  • Priority changed from minor to major
  • Type changed from Patch - Feature to Patch - Bug Fix

comment:4 Changed 5 years ago by dekarl

  • Milestone changed from 0.27 to 0.27.1

Changed 5 years ago by dekarl

revised patch

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

  • Resolution set to fixed
  • Status changed from assigned to closed

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 5 years ago by stuarta

  • Milestone changed from 0.27.1 to 0.27

Add Comment

Modify Ticket

as closed The owner will remain dekarl.
The resolution will be deleted. Next status will be 'new'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.