Franck Routier <franck.routier@axege.com> writes: > I am wondering if deferring foreign key constraints (instead of > disableing them) would increase performance, compared to non deferred > constraints
No, it wouldn't make any noticeable difference AFAICS. It would postpone the work from end-of-statement to end-of-transaction, but not make the work happen any more (or less) efficiently.
What about disc access? Won't "working" with one table, then another be faster than working with both at the same time?
