[mythtv] SQL Performance Patch
Thor Johnson
thormj at ieee.org
Wed Apr 9 23:01:57 EDT 2003
Err not a patch as such but nice enough I think it should be added to
0.8-0.9sql.txt
Run these on your mythdatabase:
CREATE INDEX progid ON record (chanid, starttime);
CREATE INDEX title ON record (title(10));
CREATE INDEX title ON program(title(10));
This will speed up the conflict resolution screen (and the other
parts where the scheduler loads from the database) a whole bunch.
(15 seconds down to ~1 second on my box).
-Thor Johnson
More information about the mythtv-dev
mailing list