[mythtv] frequent PlayBoxTransparency setting DB lookup in mythvideo

Colin Guthrie myth at colin.guthr.ie
Tue Aug 17 04:12:43 EDT 2004


Hi Brad,

Brad Fritz wrote:
> Using CVS from 8/15/04...
> 
> While experimenting with mythvideo this evening, I noticed that
> after selecting "Browse Videos" there is a loop that runs this
> query:
> 
>   SELECT data
>   FROM settings
>   WHERE value = 'PlayBoxTransparency'
>   AND hostname = 'mythfe00'
> 
> continuously at a rate of several times per second.

Hmm, I wonder if this is the problem I was seeing too in my email 
"[mythtv] [Partial PATCH+BUG Report] MythVideo high CPU usage on Browser 
& freeze on Gallery" posted last night.... (the patch didn't address 
this issue BTW)

How does the Gallery view fair for you? I'll take another look tonight 
and see if I can find anything and look at the SQL queries (as I didn't 
look at that last night). I suspect the problem I'm encountering is also 
to do with images, and hense the PlayBoxTransparency may be related....

Col.


-- 

+------------------------+
|     Colin Guthrie      |
+------------------------+
|  myth at colin.guthr.ie   |
| http://colin.guthr.ie/ |
+------------------------+


More information about the mythtv-dev mailing list