[mythtv-users] SQL Boost

[Vincent Colombo]

Sorry if this is a stupid question but I'm not all that familiar with 
MySQL. How exactly does one go about doing this?

Thanks,

Vince


On Wednesday, April 9, 2003, at 09:44  PM, Thor Johnson wrote:

> 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
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>