I was thinking of just a LIMIT clause in the SQL but after looking at it I see it would be a bit more difficult than that. The problem for me is the DB query.<br><br>- Mark.<br><br><div><span class="gmail_quote">On 2/17/06,
<b class="gmail_sendername">Joe Buckshin</b> <<a href="mailto:jbuckshin@gmail.com">jbuckshin@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 2/15/06, Mark Buechler <<a href="mailto:mark.buechler@gmail.com">mark.buechler@gmail.com</a>> wrote:<br>> I was wondering if anyone was working on or had in their scope multiple page<br>> support for MythWeb's TV listings. I have a problem with too many listings
<br>> and with them all on a single page it takes several minutes to show. I've<br>> been thinking about changing that behavior to maybe a max of 50<br>> listings/page.<br>><br>> - Mark.<br>><br>> _______________________________________________
<br>> mythtv-dev mailing list<br>> <a href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org</a><br>> <a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
</a><br>><br>><br>><br><br>The wml theme does paging out of necessity but doesn't limit the data<br>that is queried, only the displayed data. That strategy may work if<br>the network traffic or the browser rendering is slowing you down, but
<br>not if the db routine is the limiting factor. It wasn't an ideal<br>solution but worked within the theme structure.<br><br>You could also try to limit the number of timeslots shown which is a<br>parameter in config/theme_default.php, but that's probably not
<br>desirable.<br><br>I prefer to simply remove the channels I never watch.<br><br>-Joe<br>_______________________________________________<br>mythtv-dev mailing list<br><a href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org
</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</a><br></blockquote></div><br>