[mythtv] change recordedmarkup.type to tinyint?
henri naccache
hnaccache at gmail.com
Sun Apr 23 17:27:54 UTC 2006
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
More information about the mythtv-dev
mailing list