[mythtv-users] SQL Boost

Thor Johnson thormj at ieee.org
Thu Apr 10 02:44:08 UTC 2003


I posted this on the dev list, but its such a boost I think Discussion
needs to hear about it if they haven't:

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'll cut down on the loading time (Conflict resolution,
startup, etc) considerably.

-Thor Johnson



More information about the mythtv-users mailing list