> 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 -- Chris
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
