[mythtv] innodb vs myism preformance

Chris Pinkham cpinkham at bc2va.org
Fri Feb 25 01:28:01 UTC 2005


> run the query:  3019 rows in set (15.95 sec)
> 
> [
> CREATE INDEX title ON recorded (title);
> ]
> 
> run the query: 3019 rows in set (4.78 sec)

I just committed code to CVS to add an index on the recorded.title
column.  It took my times for that query down from about 3.1 down
to 1.8 seconds so I figured I'd commit it.

-- 

Chris



More information about the mythtv-dev mailing list