Mailing List Archive: SQL Boost

SQL Boost

Apr 9, 2003, 7:44 PM

Post #1 of 3 (1263 views)

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

Re: SQL Boost [ In reply to ]

vcolombo at wi

Apr 9, 2003, 7:52 PM

Post #2 of 3 (1231 views)

Permalink

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

RE: SQL Boost [ In reply to ]

thormj at ieee

Apr 9, 2003, 8:04 PM

Post #3 of 3 (1227 views)

Permalink

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

No problem. Run the command
mysql -u root

on your master backend. Then at the myql prompt,
use mythconverg

and then type the CREATE INDEX lines one by one.
After you're done, type
quit

to get out of mysql.

-Thor Johnson

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