<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v7.1.1-37812">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>RE: [mythtv-users] MythWeb Recorded Program Details page takes forever to load (Even worse on 0.27)</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif ! important;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<blockquote style="border-left: 2px solid #325FBA; padding-left: 5px;margin-left:5px;">-----Original message-----<br /><strong>From:</strong> Jean-Yves Avenard <jyavenard@gmail.com><br /><strong>Sent:</strong> Tue 10-09-2013 10:16<br /><strong>Subject:</strong> Re: [mythtv-users] MythWeb Recorded Program Details page takes forever to load (Even worse on 0.27)<br /><strong>To:</strong> Discussion about MythTV <mythtv-users@mythtv.org>; <br />On 10 September 2013 18:14, Dave Pearson <lists@the-pearsons.co.uk> wrote:<br /><br />> I commented that line out and the details page now loads pretty much<br />> instantly!<br /><br />ok.. so it's the same issue as me...<br /><br />connect to mysql on the mythconverg database (mysql -u mythtv -p mythconverg)<br />and run the following command:<br />SELECT DISTINCT settings.hostname FROM settings WHERE<br />settings.hostname IS NOT NULL AND settings.value =<br />"NetworkControlEnabled" AND settings.data = 1;<br /><br />This will return a list of hostnames...<br /><br />On my system, there were about 5 machines that did not exist anymore<br />and would resolve to my ISP's default search page which cause<br />searching for mythtv settings taking forever...<br />today my cable connection was down, and the detail page would take 10<br />minutes to load; with the internet connection working it would still<br />take 2 minutes.<br /><br />If you know of a machine that isn't in use anymore, deleted the settings with:<br />DELETE FROM `settings` WHERE `hostname` = 'machine_hostname';<br /><br /><br />That won't solve the issue of findFrontends() taking a long time, but<br />will bypass it...<br /><br />> Now, I wonder what causes the Record Program Update function to be so slow?<br />> :-)<br /><br />I have that issue too... will look into it<br />_______________________________________________<br />mythtv-users mailing list<br />mythtv-users@mythtv.org<br />http://www.mythtv.org/mailman/listinfo/mythtv-users<br /></blockquote><p>Hi Jean-Yves,</p><p> </p><p>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.</p><p> </p><p>Regards,</p><p>Dave.<br /> </p>
</body>
</html>