Hi Everyone,
I was just about to start investigating what was involved in implementing a pragma that did just this - only to find it exists already ! (ver 3.6.15) (and it does function as it says on the tin) (look at the flagPragma function "ignore_check_constraints", SQLITE_IgnoreChecks ) Any reason it's not documented here ? http://www.sqlite.org/pragma.html I'm sure it would be useful to people trying to do something similar to me ! (or conversely does it have some hidden secret nasty behaviour that I should be aware of ?) I've got a schema that has extensive check constraints on every column and we use that to constrain the values coming in through the user interface, however I also need to bulk load data into the same table through an interface that another system has already validated the data against the schema so I don't need to do it again and it speeds up my insert speed on an embedded system by about 20-30%. Many thanks Owen _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
