[mythtv] innodb vs myism preformance
danmanj at gmail.com
Wed Feb 23 19:04:07 UTC 2005
>> Adding the index didn't change much, (isn't that a primary
>>key anyway?), but recordid was int(11) in the recorded table
>> instead of being int(10). Changing it to int(10) and running
>>OPTIMIZE on the table drop the query down to 4.75 seconds.
>The output from explain will tell you if it's being used
Well EXPLAIN says it's using the primary key from record, so i assume
it's just fine.
More information about the mythtv-dev