[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.
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