Changes between Initial Version and Version 1 of Ticket #2988
- Timestamp:
- Jan 28, 2007, 9:49:08 PM (17 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #2988 – Description
initial v1 3 3 I 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. 4 4 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 }}} 5 see attached diff.