7900 shaares
161 private links
161 private links
How to configure SQLite for
Using a simple INT
with Unix millisecond timestamps is the best for performance.
COUNT
is slow, so it can be useful to keep track of them in a separate table.
Distributed SQLite databases can be achieved the same way as PostgresSQL: one writer and multiple replicated readers.
Great insights too :)