<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">hi, i have noticed that first and last showings marking is quite slow it appears to be hard coded into mythfilldatabase<br>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 <br>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 <br>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 <br>this then can be used to run the grouping query much faster (less than 10% of what it takes now )<br><br>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 )<br>this way modularization could be much more advanced with loosely coupling on the commandline <br><br><br>this is my current setup: <br><br>MythTV Version : v0.24.1-1-g347cd24<br>MythTV Branch : fixes/0.24<br>Network Protocol : 63<br>Library API : 0.24.20110505-1<br>QT Version : 4.6.2<br>Options compiled in:<br> 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<br><br></div></body></html>