[mythtv] innodb vs myism preformance
Daniel Manjarres
danmanj at gmail.com
Tue Feb 22 20:24:07 UTC 2005
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
More information about the mythtv-dev
mailing list