[mythtv-users] [PATCH] Full table scan on program table

[David Whyte]

Open Source....you gotta love it *droooool*

Dave - Don't mind me, I am a newbie to OSS (and quite enjoying the benifits)


On Sun, 05 Sep 2004 13:18:01 -0500, Kevin Kuphal <kuphal at dls.net> wrote:
> Brian Scully wrote:
> 
> >I've been tweaking this a bit, and i've got another perceptible boost, although much smaller than the last one - it rids this query of all full table scans.
> >
> >ALTER TABLE channel ADD_INDEX channelnum (channum, sourceid);
> >
> >This should probably be a unique index, but i've got some duplicate channums - maybe due to upgrades, I don't know.  I'm gonna do a little research and maybe pull out the dupes.  Sourceid isn't necessary for me (i've only got one source), but it's probably better to be generic in this case.
> >
> >
> Brian,
> 
> Good work indeed, I'd love to see if you might find even more
> optimizations, but in this case, you should drop this to the -dev list
> but you will probably want to put this in the form of a patch which
> means modifying the dbcheck.cpp file in the libmythtv folder.  When
> updating database schema, increase the version number at the top of the
> page and then add your code at the end of the UpgradeTVDatabaseSchema
> function using a dbver check for your new version number.  It is very
> straightforward and you need only mimic the other code there and
> assuming this doesn't break anything, I'm sure that Isaac would
> appreciate the effort.
> 
> Kevin
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> 
> 
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 



-- 
GMAIL is 'da bomb baby....YEAH