[sqlite] Trigger Performance

[David Burgess]

I have a table where I drop, create and insert 284,000 rows

time taken 3.39 seconds.

I add the following trigger


CREATE TRIGGER x_trigger BEFORE INSERT ON x
WHEN
        0 = 1
           BEGIN SELECT RAISE ( ABORT, 'raise' );
END;

time taken 4.49 seconds.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users