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 <br> <br>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