Opened 14 years ago

Closed 14 years ago

#1627 closed defect (invalid)

mythweb scales very badly with lots of channels

Reported by: chrisb@… Owned by: xris
Priority: major Milestone: unknown
Component: mythweb Version: 0.19
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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?

Change History (1)

comment:1 Changed 14 years ago by kkuphal

Resolution: invalid
Status: newclosed

Please read the TicketHowTo before opening a ticket. Trac is not a forum for complaints or enhancement requests.

Note: See TracTickets for help on using tickets.