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
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