[mythtv] mythweb patch: "movies" page, bugfixes
Grant Taylor
mythtv-dev@snowman.net
Mon, 09 Dec 2002 11:34:59 -0500
>>>>> mythtv-dev@snowman.net writes:
> Grant, I'm having a little trouble with your patch.. judging by the
> query your added fetchListings() function is doing its returning a
> whole lot of results and its exhausting the default 8M script
> resource limit set in php.ini.
> So basically, I was just wondering how it is that it works for you,
Perhaps the small number of channels I have (25ish) or the fact that I
only have listings through thursday loaded at the moment.
The proper fix would be to twiddle the query to return only shows >=
70 minutes. This is what I tried to do in the first place, but mysql
didn't like having duration, or the unix_time computation it comes
from, as a subexpression in the WHERE clause. Perhaps you can concoct
an expression that mysql will take?
--
Grant Taylor - gtaylor@picante.com - http://www.picante.com/~gtaylor/
Linux Printing Website and HOWTO: http://www.linuxprinting.org/