[mythtv-users] performance about marking of first and last showings and loosely coupling of actions

sususu xunspam-sususu at yahoo.com
Tue Apr 10 10:56:26 UTC 2012

hi, i  have noticed that first and last showings marking is quite slow it appears to be hard coded into mythfilldatabase
basically the problem is that mysqls needs where not addressed, i have captured the query during execution and recreated one with very similar output by use of indexing 
yes, i know there is the problem of mysql that keys must not exceed a certain length and that description and title  do exceed this very much 
however since usually the differentiating elements are provided in the beginning of the text i argue that a second table could be generated employing an index and copying only the shortened text into it 
this then can be used to run the grouping query much faster  (less than 10% of what it takes now )

it would be perfect if all such secondary actions would be stand alone programs/scripts and their invocation would be defined in some sort of config (fileconfig over dbconfig )
this way modularization could be much more advanced with loosely coupling on the commandline 

this is my current setup: 

MythTV Version   : v0.24.1-1-g347cd24
MythTV Branch    : fixes/0.24
Network Protocol : 63
Library API      : 0.24.20110505-1
QT Version       : 4.6.2
Options compiled in:
 linux debug using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_directfb using_dvb using_firewire using_frontend using_hdhomerun using_hdpvr using_iptv using_ivtv using_joystick_menu using_lirc using_mheg using_opengl_video using_opengl_vsync using_qtdbus using_qtwebkit using_v4l using_v4l2 using_x11 using_xrandr using_xv using_bindings_perl using_bindings_python using_mythtranscode using_opengl using_vdpau using_ffmpeg_threads using_live using_mheg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120410/7532449e/attachment.html>

More information about the mythtv-users mailing list