> 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

_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev

Reply via email to