Hi, I'm having a table of file names along with hashes and so on. In order to make sure that we keep a record, I had put a trigger on UPDATE and INSERT which would set the column 'modified' (REAL, Julian day) to the time of the change. However, this slows down any INSERTs (even those seemingly unrelated to this table) considerably.
Is there a better method to achieve the same, i.e. keep track of when a row was last changed? Thanks, // Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users