[mythtv] mythweb sql query

Chris Petersen lists at forevermore.net
Tue Jun 3 09:34:36 EDT 2003


> However, I want to point out that the reason I changed it from
> querying once per channel+slot is that some folks have many channels,
> and perhaps multiple video-sources.  I often have >60k records in my
> program table, and that's for just one video-source.  The previous
> code took 8-12 seconds to generate a listings page on my box.

yeah, that's why I switched to a single query that returns ALL program
data.  It should work out pretty well.

-Chris



More information about the mythtv-dev mailing list