Andrew Cunningham wrote: >I have noticed that when FOREIGN KEY is in DEFERRED mode and a FOREIGN KEY >violation occurs, SQLite will continue to run, but performance slows down >by about 1000x. Breaking into the code shows that it seems to be >continually re-reading the database. When I finally get to COMMIT , an
When any violation occurs it's wise to use '.bail on' (ref. https://www.sqlite.org/cli.html ) and eventually abort the application (creating a core dump if necessary to get an investigation done by a developer) as soon as it stops to run for this reason. Kind regards |?Cordiali saluti | Vriendelijke groeten | Freundliche Gr?sse, Klaas `Z4us` V ?- LinkedIn 437429414
