[mythtv-users] slow mythweb?

[Udo van den Heuvel]

Michael T. Dean wrote:
> On 04/19/2008 12:52 PM, Udo van den Heuvel wrote:
>> So for now I can only reduce the stuff that ends up in the BUSQ (like
>> recording schedules I assume) and tune mysql to the fullest to get
>> maximum performance on this small machine (1.2 Ghz VIA Esther w/ 1 GB of
>> RAM).
> 
> Or run MySQL on a different (more powerful) host on the network.

On the other hand:
All data under /var/lib/mysql/mythconverg amounts to about 23 megs over
here.
This should fit easily into RAM, so stuff should be very quick.
Normally the machine is ~50% idle (with frontend running), so there's
enough CPU-cycles to do some queries?

So how would I get most of mysql's data(base) in RAM?
Any tweaks?

Kind regards,
Udo