[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