Reply to thread

i made some additional indexes in the MySQL Database and got a small performance boost.

Here are the SQL-Statements. Maybe these Statements can be included in future releases.


ALTER TABLE `setting` ADD INDEX ( `tag` ) ;

ALTER TABLE `tuningdetail` ADD INDEX `IDX_TuningDetails2` ( `networkId` , `transportId` , `serviceId` );

ALTER TABLE `channel` ADD INDEX ( `isRadio` ) ;

ALTER TABLE `channel` ADD INDEX ( `isTv` ) ;

ALTER TABLE `channel` ADD INDEX ( `sortOrder` ) ;

ALTER TABLE `radiogroupmap` ADD INDEX ( `SortOrder` ) ;


Top Bottom