[mythtv-users] slow mythweb?

[Udo van den Heuvel]

Andrew Williams wrote:
> 2008/4/21 Udo van den Heuvel <udovdh at xs4all.nl>:
(...)
>> channel.callsign like "NL3" in the Search Phrase field.
>>
>> Every now and then mythbackend starts consuming 60+% and mysql 30+% with
>> about 50% of the CPU being 'nice'.
>> This lasts for a few minutes as it appears. Mythweb is getting very slow
>> in this case.
> 
> Use = instead of LIKE, even with a quick test on my system using LIKE
> instead of = for callsign doubled the runtime of the query when joined
> with just the program table. Im sure the BUSQ would reference in a few
> other tables as well. Also my query was only over a day of data, I can
> imagine over a week or two it would take a while to execute.

Made the changes, will keep an aeye on differences.
I have only a few days worth of program data and only 3 to 4 channels.

> While it wont be a silver bullet for your issues, it should shave a
> few seconds off the mysql time.

Thanks!