<div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style="direction: ltr;"><div style="direction: ltr;"><span class="q"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;"><div style="direction: ltr;"><div>I had
three problems. The first was that the all *.js files were retrieved
for every single page. Look into the apache log file
(/var/log/http/...) if that is the case. After I had switched between
different browsers and tried to open the mouseovers.js file explicitly
in a browser, that problem disappeared and the load time for a listings
page dropped from 40 seconds to 12 seconds.</div></div></div></blockquote></span></div><div style="direction: ltr;"><div><br>i
looked in the httpd log and the entries and did see the *.js files are
being retrieved for every single page. how do you open the *.js
explicitly? how do you make that stick?
</div></div></div></blockquote><div><br>
I do not know exactly what is going on. The browser should cache these
*.js files in my opinion, so there is probably something going wrong.<br>
I think I entered something like
<a href="http://niels.dybdahl.dk/mythweb/tv/mouseovers.js">http://niels.dybdahl.dk/mythweb/tv/mouseovers.js</a> or
<a href="http://niels.dybdahl.dk/mythweb/tv/js/mouseovers.js">http://niels.dybdahl.dk/mythweb/tv/js/mouseovers.js</a> or
<a href="http://niels.dybdahl.dk/mythweb/mouseovers.js">http://niels.dybdahl.dk/mythweb/mouseovers.js</a> or
<a href="http://niels.dybdahl.dk/mythweb/js/mouseovers.js">http://niels.dybdahl.dk/mythweb/js/mouseovers.js</a> in my browser and
after that it did not retrieve those *.js files anymore and I had a
significant speed increase. A strange thing is that I had a speed
increase on all three PCs that I use for accessing MythWeb, not just
the one where I entered the URLs, so maybe something else was the real
cause for the speed increase.<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style="direction: ltr;"><div style="direction: ltr;">
<div>also note the entries in the httpd log for konquerer look the
same as those for firefox under windows. why the difference in
page load time?</div>
</div></div></blockquote><div><br>
It is strange to me too. I have just reread my old postings and I had a
lot of mysql activity during the initial 40 seconds delay. So maybe you
should turn on mysql logging to see what is actual going on. Do you
also have a lot mysql activity during the delay ?<br>
You can turn mysql loggin on by adding the line log=/var/log/mysql.log
to the [mysqld] section of the file /etc/my.cnf, create the
/var/log/mysql.log file and restart mysql. If you do have a lot of
mysql activity, then you will see what it is actually doing during that
delay.<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style="direction: ltr;"><div style="direction: ltr;"><span class="q"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;"><div style="direction: ltr;"><div>The
second problem was due to my high number of recording schedules. The
program listings page retrieves extra information for every single
program that has been set to be recorded, no matter if the program is
within the displayed time frame or not. And I have around 200 scheduled
recordings each week... I fixed it by commenting the following lines
out of the file /var/www/html/mythweb/includes/programs.php:
<br><div><br><img alt="">/* elseif ($this->chanid) {<br> unset($this->filename);
<br>
// Kludge to avoid redefining the object, which doesn't work in php5<br> $tmp = @get_object_vars(load_one_program($this->starttime, $this->chanid));<br>
if (is_array($tmp) && count($tmp) > 0) {
<br>
foreach ($tmp as $key => $value) {<br>
$this->$key = $value;<br> }<br> }<br> }*/</div></div>
</div></div></blockquote></span></div><div style="direction: ltr;"><div><br>i
thought this was a band-aid for the problem. you used the word
kludge yourself. it may fix the symptom but it is not the root
cause. </div></div></div></blockquote><div><br>
There are at least two different problems. Uncommenting these lines
completely solves one of the problems. I did not use the word kludge,
it just happens to be in the code that I have commented out.<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style="direction: ltr;"><div style="direction: ltr;"><span class="q"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;"><div style="direction: ltr;">The
third problem is related to the recorded programs page. MythWeb still
runs through all programs to see if their icons are missing or
something like that. Apparently it has problems regenerating a couple
of them, and that slows the page down. I do not use that page very
much, so I have not looked deeper into that problem.
</div></div></blockquote></span></div><div style="direction: ltr;"><div><br>the
channel logo icons on the listing page or the preview icons on the
recordings page? </div></div></div></blockquote><div><br>
It is the preview icons, as there were entries in the log indicating that video files were opened and decoded. <br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style="direction: ltr;"><div style="direction: ltr;"><div>i only have seven recordings and each has a
vaild *.png. the listings do show channel logo icons but only for
one channel. i do have icons for some of the other channels but
they are not displayed. i wonder why?
</div></div></div></blockquote><div><br>
Does the apache log give any hints ?<br>
<br>
Niels Dybdahl<br>
</div></div><br>