On 1 Mar 2017, at 9:11pm, Deon Brewis <[email protected]> wrote: > "But look how much space and processing time it would take up" > > Can you clarify what you mean by "space" ?
Your triggers have to be stored. Every time they’re activated (each time you insert a row) they have to be run. That requires SQLite to grab enough memory and/or disk space to run the triggers and to construct any temporary indexes they require. Also, it’s a nightmare to debug in comparison with just creating one extra index. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
