[mythtv-users] MythWeb Recorded Program Details page takes forever to load (Even worse on 0.27)

[Dave Pearson]

-----Original message-----
From:Jean-Yves Avenard <jyavenard at gmail.com>
Sent:Tue 10-09-2013 10:16
Subject:Re: [mythtv-users] MythWeb Recorded Program Details page takes forever to load (Even worse on 0.27)
To:Discussion about MythTV <mythtv-users at mythtv.org>; 
On 10 September 2013 18:14, Dave Pearson <lists at the-pearsons.co.uk> wrote:

> I commented that line out and the details page now loads pretty much
> instantly!

ok.. so it's the same issue as me...

connect to mysql on the mythconverg database (mysql -u mythtv -p mythconverg)
and run the following command:
SELECT DISTINCT settings.hostname FROM settings WHERE
settings.hostname IS NOT NULL AND settings.value =
"NetworkControlEnabled" AND settings.data  = 1;

This will return a list of hostnames...

On my system, there were about 5 machines that did not exist anymore
and would resolve to my ISP's default search page which cause
searching for mythtv settings taking forever...
today my cable connection was down, and the detail page would take 10
minutes to load; with the internet connection working it would still
take 2 minutes.

If you know of a machine that isn't in use anymore, deleted the settings with:
DELETE FROM `settings` WHERE `hostname` = 'machine_hostname';


That won't solve the issue of findFrontends() taking a long time, but
will bypass it...

> Now, I wonder what causes the Record Program Update function to be so slow?
> :-)

I have that issue too... will look into it
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-users

Hi Jean-Yves,

 
I've added the flush() command to the details.php script and that certainly allows the rest of the page to load pretty much instantly. I've now deleted the non-existent frontends from my database and that has sped up the rendering of the "Play Recording on Frontend" section of the page significantly.

 
Regards,

Dave.
 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130910/8502df93/attachment.html>