I create a SQLite file like this:sqlite3 output.db < myinserts.sqlUnfortunately it takes hours, so I want to speed it up by using the following PRAGMAs:PRAGMA synchronous=OFFPRAGMA count_changes=OFFPRAGMA journal_mode=MEMORYPRAGMA temp_store=MEMORYQUESTION: How to set them on the command line?It is for a script so I don't want interactive mode, I want to do all in a single command line.
How to specify PRAGMAs in an sqlite3 command line call?
bash;sqlite