[mythtv] [Patch] Logging to database PLUS automatic mythfilldatabase

Per Åge Sørvik peraage at leneogperaage.com
Fri Feb 27 14:39:28 EST 2004


Matt White wrote:

> I was trying to make the log call fairly quick, since it's being run
> in-line during regular operation and not in its own thread.  I don't
> know how much of an issue that is - like you say, it should be a pretty
> simple check.  I'll do some experimenting...
>
> I think it should be fairly simple to just do
>
> SELECT logid FROM mythlog WHERE module=<modulename> ORDER BY ldate ASC;
>
> and then just deleting the first x events returned to get down under the
> limit...
>
Hm, how about using autoincrement id, and use last_insert_id(); to get 
the last inserted id ?

-- 

peraage


More information about the mythtv-dev mailing list