[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