[mythtv-users] What does this SQL query do in MythWeb ?

[Brian Wood]

On Mar 6, 2006, at 4:10 AM, Brian Wood wrote:

>
>
> On Mar 6, 2006, at 3:49 AM, Niels Dybdahl wrote:
>
>> I have commented the following lines out of the file /var/www/html/
>> mythweb/includes/programs.php:
>>
>> /*            elseif ($this->chanid) {
>>                 unset($this->filename);
>>             // Kludge to avoid redefining the object, which doesn't
>> work in php5
>>                 $tmp = @get_object_vars(load_one_program($this-
>>> starttime, $this->chanid));
>>                 if (is_array($tmp) && count($tmp) > 0) {
>>                     foreach ($tmp as $key => $value) {
>>                         $this->$key = $value;
>>                     }
>>                 }
>>             }*/
>>
>>
>> It has speeded my MythWeb program listing up to around 2 seconds
>> and I have not noticed any missing details in the listing.
>> Note however that this file (programs.php) probably is used by
>> other modules, so they may have been impacted.
>>
>
> Well maybe 7 or 8 seconds in my case, but I've got all those
> DishNetwork channels, it used to take a l-o-n-g time.
>
> We'll see what it breaks, but thanks.


That didn't take long.

What it breaks is moving into the next time period with the right  
arrow at the top-right of the page. That time period did contain a  
scheduled recording.

This hung Safari completely, restoring the lines fixed it.

Good idea though, thanks for the effort.