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

Jay R. Ashworth jra at baylink.com
Sun Sep 5 13:57:55 EDT 2004


On Sun, Sep 05, 2004 at 01:36:01PM -0400, 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.

Hey, Brian?  You go, boy, but you should probably be posting this stuff
on the devel list...  I understand Isaac is probably on the edge of
another big patch committing run shortly, so it's well timed.

Cheers,
- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

	"You know: I'm a fan of photosynthesis as much as the next guy,
	but if God merely wanted us to smell the flowers, he wouldn't 
	have invented a 3GHz microprocessor and a 3D graphics board."
					-- Luke Girardi


More information about the mythtv-users mailing list