-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Chris Pinkham wrote: |>This query takes 22 seconds with MyISAM, and 15 with innodb, and |>happens everytime I delete or activate a recording, and is always |>running when I see those pauses that were driving me crazy. The log |>says there is no lock time, so my theory of this being a resource |>locking issue seems disproven. At this point I am too tired to make |>sense of this thing, but I figureed i should let you guys know what I |>figured out so far. | | | Just ran this on my Athlon 700 combination fileserver/DB-server and it | ran in 3.88 seconds and returned 1020 rows. Here's rowcounts for a few | of the tables involved: | | recorded: 174 | oldrecorded: 3425 | program: 26231 |
On my Duron1000 I get 220 rows in set (0.57 sec)
but I have some non-standard indexes added and some primary keys where I thought they where needed. (Nothing scientific)
recorded: 137 oldrecorded: 928 program: 28193 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux)
iD8DBQFCGkc5yPEuXJ2RxGYRAnRYAJ4hk+nJMjOPTi052vvqz+5NU7j/dwCcDouO 2j/cTFSdXiL2CzU3BmbB4MQ= =JDUh -----END PGP SIGNATURE----- _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
