Julian Foad <julian.f...@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
