[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