<br><br><div><span class="gmail_quote">On 3/15/06, <b class="gmail_sendername">Rusty McEacharn</b> <<a href="mailto:mceachrw@gmail.com">mceachrw@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
i just upgraded to .19 from .18.1 and spent three hours last night trying to improve the performance of mythweb. i read every recent post about slowness and tried the following with no success:<br>-optimize_mythdb.pl<br>
-move the .htaccess directives to
httpd.conf<br>-add the following to my.conf<br> key_buffer = 48M<br> max_allowed_packet = 8M<br> table_cache = 128<br> sort_buffer_size = 48M<br> net_buffer_length = 8M<br> thread_cache_size = 4<br> query_cache_type = 1
<br> query_cache_size = 4M </blockquote><div><br>It seems you did not read my postings...<br> <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;">
the backend performs fine. performance before and after the upgrade is similar. but, i normally use mythweb from my desktop box (winxp) and .19 performance is horrible. so...i stuck a live linux cd in my windows box. to my surprise, .19 performance was as it should be. can a few dual booters out there do some testing to confirm this problem? other suggestions to fix this?
<br><br>backend: 700 mhz celeron, i810, 256 mb ram, fc3 up to date using atrpms<br>desktop (windows): a64 3000, nf4, 1000 mb ram, xp pro up to date using windows update<br>desktop (live linux): same hardware running slax
v5.0.7 using copy2ram, like knoppix with everything in ram<br><br>page load times<br>live linux windows task<br>9 sec 38 sec listings, ~150 channels<br>3 sec 30 sec recorded programs, 7 episodes
<br>1 sec 1 sec backend status<br>3 sec 30 sec upcoming recordings<br>3 sec 30 sec search
</blockquote><div><br><br>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.<br><br>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 id="mb_2"><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><br>Somebody stated that it does not work with a Safari browser on MacOSX. I have tested my setup on a Safari browser and it works. I still has not found any missing information in any of the MythWeb pages, so the lines above seem unnecessary. The time needed to load the page is now down to 2 seconds.
<br><br>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.
<br><br>Niels Dybdahl<br></div><br>