id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 1627 mythweb scales very badly with lots of channels chrisb@… xris "When mythtv has a large number of channels configured, in my case 470, mythweb takes forever to display the channel grid. This is partly because it has no concept of paging, so will display all 470 channels at once (creating quite a large HTML page). Secondly, it's down to the INSANE number of SQL queries it takes to get the data for the channel grid. On my system, it did 2135! On further investigation, it appears that mythweb is doing one query for every channel, and one query for every program on every channel. That's insane - surely it can get more than one result at a time?" defect closed major unknown mythweb 0.19 medium invalid 0