Re: [PATCH in progress] Ref-counting for pristine texts

Julian Foad <julian.foad_at_wandisco.com> writes:

> The only case that SQLite doesn't handle automatically is the
> replacement part of "INSERT OR REPLACE INTO ...": it doesn't fire the
> "delete" trigger in that case.

http://www.sqlite.org/lang_conflict.html

suggests that you need to enable recursive triggers.

I suspect that triggers are the most efficient way to implement
reference counting (no need for separate queries) but does it have a
noticeable effect on performance? Is checkout slower for example?

-- 
Philip