[mythtv-users] SQL Boost

[Thor Johnson]

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