On Tue, May 10, 2011 at 4:32 PM, Lynton Grice
<lynton.gr...@logosworld.com>wrote:
> I like the ON INSERT trigger.....good idea. So perhaps you have a
> "setLogMaxSize" type function in C that allows the client program to say
> "hey, I only want the log to hold a max of 10 000 records".....and then
> I do a select count(*) inside the ON INSERT type trigger and delete
> entries if "num records > max"......
>
The problem i see with that is that once the log has overflowed one time,
further log calls will run a DELETE very often. Why?
max_log_count=10
current_log_count=9
log("foo");
current_log_count=10 == clean up ==
current_log_count=9
log("bar")
current_log_count=10 == clean up ==
current_log_count=9
...
ad naseum
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
