EExcel 丞燕快速查詢2

EExcel 丞燕快速查詢2
EExcel 丞燕快速查詢2 https://sandk.ffbizs.com/
顯示具有 sqlite 標籤的文章。 顯示所有文章
顯示具有 sqlite 標籤的文章。 顯示所有文章

sqlite selft host turso libSQL

https://turso.tech/

https://github.com/tursodatabase/libsql


self host


binary

https://virtala.dev/posts/libsql-self-hosting/

docker

https://github.com/tursodatabase/libsql/blob/main/docs/DOCKER.md

nosql key/value on sqlite

https://github.com/kujirahand/node-sqlite-kvs/blob/master/lib/sqlite-kvs.js

https://github.com/lukechilds/keyv/blob/master/src/index.js

[轉]Huge performance hit on a simple Go server with Docker

https://www.reddit.com/r/golang/comments/8ojjoj/huge_performance_hit_on_a_simple_go_server_with/

Docker's disk I/O was the bottleneck!

Solved: Disk I/O was the problem. Even though I'm on Debian 9.4, changing to an in-memory sqlite allowed Docker to push 2.9k reqs/sec. Credits to /u/Willson50 for the amazing find!


With file=dco.sqlite3?mode=memory, Docker can push ~2.9k req/sec.



Other way:

PRAGMA journal_mode=WAL;
PRAGMA synchronous=NORMAL;

https://www.sqlite.org/wal.html