[mythtv] SQL Performance Patch
Andy Davidoff
dert at pobox.com
Wed Apr 9 23:08:25 EDT 2003
I've been using these indexes for awhile; just try doing conflict
resolution on an anytime-anywhere recording of "Paid Programming"
without 'em. My machine was hung for at least a couple minutes. :-D
On Apr 09, at 22:01, Thor Johnson encoded a 0.6K recording:
> 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).
More information about the mythtv-dev
mailing list