>> Adding the index didn't change much, (isn't that a primary >>key anyway?), but recordid was int(11) in the recorded table >> instead of being int(10). Changing it to int(10) and running >>OPTIMIZE on the table drop the query down to 4.75 seconds.
>The output from explain will tell you if it's being used >Mark Well EXPLAIN says it's using the primary key from record, so i assume it's just fine.
_______________________________________________ mythtv-dev mailing list mythtv-dev@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev