[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