Bubu Bubu wrote: > Can someone tell me if there can really be performance issues when one uses > foreign keys in their database?
The documentation <http://www.sqlite.org/foreignkeys.html#fk_indexes> warns against a case where some operations can be slow if you do not have an index on the child key. But if you have all suggested indexes, then all the checks done to enforce (foreign key) constraints are simple index lookups. These are mostly harmless, unless the number of rows you are changing is so large that all the individual operations add up to something noticeable. (If you predict that that happens, you can simply disable foreign key constraint checks.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users