3 ms·
There is zero reason a carefully engineered application utilizing SQLite cannot completely saturate the IO capabilities of the host it resides on. Going even f
by bob1029 6y ago
There is zero reason a carefully engineered application utilizing SQLite cannot completely saturate the IO capabilities of the host it resides on.
Going even further, there are no competing technologies (i.e. hosted SQL solutions) which, when running in single node/instance mode, are competitive with the performance of well-tuned SQLite.
PRAGMA journal_mode=WAL makes all the difference in the universe.