Also, another issue when not in WAL mode is that a long read will actually have a write lock and block writes.