Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

3
  • 5
    Just an update on the whole story: We've been allowed to use foreign keys now, on the notion that they may be disabled, if they result in a performance loss. So thanks everyone for your good points :-) Commented Feb 25, 2010 at 6:54
  • We disabled them. They are nice but kill performance if you are performing many single inserts and deletes on tables with large amount of constraints AND which contain a higher number of records (i.e 100k or 1000K+). In our case to import one matrix took minutes to import. When we disabled constraints, it took a few seconds. Commented Oct 13, 2021 at 16:31
  • Have you moved to a another job now? I would. Commented Nov 3, 2021 at 9:02