Changes between Initial Version and Version 1 of Ticket #2988


Ignore:
Timestamp:
Jan 28, 2007, 9:49:08 PM (17 years ago)
Author:
xris
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #2988 – Description

    initial v1  
    33I still have the affected queries if you would like to see them.  Some are rather large, so I opted to leave them out of the ticket.
    44
    5 {{{
    6 ALTER TABLE recorded     ADD INDEX (recgroup, endtime);
    7 ALTER TABLE recorded     ADD INDEX (deletepending, lastmodified);
    8 ALTER TABLE record       ADD INDEX (maxepisodes);
    9 ALTER TABLE storagegroup ADD INDEX (hostname);
    10 ALTER TABLE channel      ADD INDEX (sourceid);
    11 ALTER TABLE mythlog      ADD INDEX (module);
    12 ALTER TABLE record       ADD INDEX (type);
    13 ALTER TABLE record       ADD INDEX (search);
    14 }}}
     5see attached diff.