[mythtv] Channel changing Bugs...

[Andy Davidoff]

It's a widely-used technique to join on multiple columns, too. ;-)

It seems that people (mdz, others?) want to link the tables by sourceid and
channel number, so why have the chanid field if we're not going to use it?

Empirical evidence suggests that mythtv-dev'ers don't care a whit for small
database sizes or faster indexes, but YMMV (and I hope to $DEITY it does).


On Apr 09, at 16:59, Chris Palmer encoded a 0.7K recording:
> Andy Davidoff wrote
> > Frankly, I don't think it serves any purpose in an ideal model.
>
> It's a widely used technique with releation databases to make the data
> more compact (less storage, faster indexes, etc).  It doesn't help
> readability, tho, but it does give you everything you need in one field
> to link to the appropriate tables to get the other info you'd want (like
> source and channel number).