[mythtv] change recordedmarkup.type to tinyint?

[henri naccache]

is there a reason why recordedmarkup should have "int" as the type for
chanid and type?

it seems that for type tinyint would work, and for chanid smallint

the reason i'm asking is that my recordedmarkup table is pretty big (over a
million rows),  and i believe that making those two fields smaller would
speed stuff up (allowing more rows to be in the cache?)

thanks

henri


mysql> desc recordedmarkup;
+-----------+------------------+------+-----+---------------------+-------+
| Field     | Type           | Null | Key | Default             | Extra |
+-----------+------------------+------+-----+---------------------+-------+
| chanid    | int(10) unsigned |      | PRI | 0                   |       |
| starttime | datetime         |      | PRI | 0000-00-00 00:00:00 |       |
| mark      | bigint(20)       |      | PRI | 0                   |       |
| offset    | varchar(32)      | YES  |     | NULL                |       |
| type      | int(11)          |      | PRI | 0                   |       |
+-----------+------------------+------+-----+---------------------+-------+
5 rows in set (0.00 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20060423/370573e8/attachment.htm