[mythtv-users] MythWeb (0.19) listing much slower than frontend

[Steve]

On 3/2/06, Niels Dybdahl <Niels at dybdahl.dk> wrote:
> Hi,
>
> I have upgraded from version 0.18.1 to version 0.19 and now my MythWeb is
> much slower to show the program listings than before.
> It takes around 40 seconds to open the program listing in MythWeb even
> though I only have 9 visible channels (and only 5 populated channels). When
> I open the program listing in mythfrontend it only takes 1-2 seconds.
>
> During the 40 seconds mysqld uses most of the CPU time, while httpd also
> uses some.

I have the same issue which wasn't present prior to 0.19.  The
Listings page takes about 11 seconds to generate on modern hardware,
and mysqld pegs the cpu most of that time.  My work-around has been to
enable mysql query caching, which makes subsequent page reloads quick,
but this doesn't resolve the issue.  My mysql config additions:

[mysqld]
query-cache-type = 1
query-cache-size = 20M