[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