[mythtv-users] slow mythweb?

[Udo van den Heuvel]

Michael T. Dean wrote:
> On 04/24/2008 01:54 PM, Udo van den Heuvel wrote:
>> Fixes? Just gives me another problem:
>>
>> 2008-04-24 19:53:14.396 Using runtime prefix = /usr, libdir = /usr/lib
>> 2008-04-24 19:53:14.408 Cannot locate your home directory. Please set
>> the environment variable HOME or MYTHCONFDIR
>> 2008-04-24 19:53:14.409 Failed to init MythContext, exiting.
>>
>> I could (re)start the backend perfectly before this `upgrade`.
>> Any idea?
> 
> Fix your environment.  You need to set a valid value for the HOME 
> environment variable (in whatever environment you're using to start Myth 
> programs--including init scripts).

The error was 'wrong'.
It was a database issue.

So back to debugging 0.22 trunk.

In the log I see messages like:

2008-04-24 20:20:14.335 Trying to bind a value to placeholder :NR1RECID
without occurance in the prepared query. Ignoring it.
Query was: "INSERT INTO recordmatch (recordid, chanid, starttime,
manualid) SELECT record.recordid, program.chanid, program.starttime,
IF(search = 5, record.recordid, 0) FROM (record, program INNER JOIN cha
nnel       ON channel.chanid = program.chanid)  WHERE record.recordid =
:NR0RECID AND program.manualid = 0 AND ( channel.callsign = "NL2" AND
program.starttime < DATE_ADD( NOW( ) , INTERVAL 8 HOUR )
 ) AND (NOT ((record.dupin & 32) AND program.previouslyshown))  AND (NOT
((record.dupin & 64) AND program.generic > 0))  AND (NOT ((record.dupin
& 128) AND (program.previouslyshown
            OR program.first = 0)))  AND channel.visible = 1 AND
((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type =
10)  OR  ((record.station = channel.callsign)   AND   ((record.type =
 3)    OR   ((TIME_TO_SEC(record.starttime) =
TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)      OR
   ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)
AND       ((record.
type = 5)        OR       ((TO_DAYS(record.startdate) =
TO_DAYS(program.starttime))         )

What does this mean? Is it bad? Can be ignored?