ghost
commented
9 years ago inserting 255 rows without the above pragma takes ~30 seconds, with the pragma ~1 second.
Closed ghost closed 9 years ago
ghost
commented
9 years ago inserting 255 rows without the above pragma takes ~30 seconds, with the pragma ~1 second.
When sqlite is being used for real and not just testing, the default journal_mode and synchronous sqlite pragma are a significant performance penalty.
PRAGMA journal_mode=MEMORY PRAGMA synchronous=OFF
Is less secure but faster and sqlite is not recommended for production environments.
Signed-off-by: Loic Dachary loic@dachary.org