[mythtv] innodb vs myism preformance

[Mark]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Daniel Manjarres wrote:
| So this is the structure of the 3 tables in my db. I guess the first
| thing is to make sure they are not on crack. The next thing is to
| figure out if I should be adding any indices or what to speed things
| up. I apparently have 6 times the recordings that y'all have, so maybe
| thats where I need to look. But I am not a SQL hacker, so I am not
| sure how to proceed.

Stick an EXPLAIN in front of the query
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFCGlWpyPEuXJ2RxGYRAo1OAJ4uMHpi9UeZJjG9R/QKtoreAs8lIwCfRvKG
CxQ/zWUsfChXWNq3ghtFrFM=
=qBEm
-----END PGP SIGNATURE-----