search

KalinNonchev / gnomAD_DB

This package scales the huge gnomAD files to a SQLite database, which is easy and fast to query. It extracts from a gnomAD vcf the minor allele frequency for each variant.
MIT License
35 stars 10 forks source link

PRAGMA journal_mode=WAL; #11

Closed KalinNonchev closed 2 years ago

KalinNonchev commented 3 years ago

Should we add PRAGMA journal_mode=WAL; to the database schema

Hoeze commented 3 years ago

Only needed for parallel read+write, see this article: https://www.skoumal.com/en/parallel-read-and-write-in-sqlite/ Does not hurt other features though, so can be enabled by default.