[mythtv] innodb vs myism preformance

[Daniel Manjarres]

Mark Edwards wrote:

>It's actually quite likely to work miracles, particularly if you have just
>repeatedly changed your table type ;)
>It will rebuild your indexes again and allow then to be used for queries.
>Which is nice.
>  
>

Now it's 19.19 seconds for 3068 rows to be returned using innodb.
before it was 15 seconds for ~2000 rows with innodb, or 22 seconds for 
the same with MyISAM.

So yes it is faster now if you normalize by speed per result row, but it 
wasn't quite a miracle.

thanks anyway.........

Dan Manjarres