I create a SQLite file like this:
sqlite3 output.db < myinserts.sql
Unfortunately it takes hours, so I want to speed it up by using the following PRAGMAs:
PRAGMA synchronous=OFF PRAGMA count_changes=OFF PRAGMA journal_mode=MEMORY PRAGMA temp_store=MEMORY
QUESTION: 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.