Are you using ‘sqlite3’ or ‘better-sqlite3’?
If you enable write ahead logging better-sqlite3 is about an order of magnitude faster.
I’ve also heard that Bun’s built in bindings are even faster than better-sqlite3 but I haven’t tested it myself
Stuart Bowman
npub1lu…827lj
2024-04-15 15:48:43
in reply to nevent1q…tw2c
Author Public Key
npub1lunaq893u4hmtpvqxpk8hfmtkqmm7ggutdtnc4hyuux2skr4ttcqr827ljPublished at
2024-04-15 15:48:43Event JSON
{
"id": "94c53239f9f4b203bb1f0c10967ee315725345f73b70abd886df72c660cb2da7",
"pubkey": "ff27d01cb1e56fb58580306c7ba76bb037bf211c5b573c56e4e70ca858755af0",
"created_at": 1713196123,
"kind": 1,
"tags": [
[
"e",
"efa33925fbd35433ccfc137569702e077cfc0294cbc9a19cc88bca73e71bb022",
"",
"reply"
],
[
"p",
"79c2cae114ea28a981e7559b4fe7854a473521a8d22a66bbab9fa248eb820ff6"
],
[
"e",
"efa33925fbd35433ccfc137569702e077cfc0294cbc9a19cc88bca73e71bb022",
"",
"root"
]
],
"content": "Are you using ‘sqlite3’ or ‘better-sqlite3’?\n\nIf you enable write ahead logging better-sqlite3 is about an order of magnitude faster.\n\nI’ve also heard that Bun’s built in bindings are even faster than better-sqlite3 but I haven’t tested it myself",
"sig": "40250fd50c61bf967a6d33f6b7e8bb4012aa7a6d3ea70d537bf0f7decc8b74bb9d1f449dc7fd218273083b35de0b557d64f4db3abee0a4b028be5502d5abd30b"
}