On Tue, May 27, 2014 at 2:11 PM, Drago, William @ MWG - NARDAEAST < william.dr...@l-3com.com> wrote:
> All, > > Is there any difference between using REPLACE as opposed to deleting > records and then inserting new ones to take their place? > REPLACE only deletes records when it is absolutely necessary to preserve UNIQUE constraints on an insert. As long as you restrict your deletes to records that would otherwise cause a uniqueness conflict, then the result will be the same. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users