A proper SQLite database shouldn't have issues with this amount of traffic. D1 isn't just SQLite though, it's SQLite + an API.
I would try using SQLite-in-DO instead of using D1. There's a good blog post about it here: https://blog.cloudflare.com/sqlite-in-durable-objects/
Secondly I would look at splitting up the database into multiple databases.
Kevin Åberg Kultalahti
npub106…ptw9x
2025-11-17 11:19:02 UTC
in reply to nevent1q…n6xk
Author Public Key
npub106wfyjh9y4wftfz5629w392j58sgr7pg44xuqwq4pz6sjxyvse0qcptw9xPublished at
2025-11-17 11:19:02 UTCEvent JSON
{
"id": "c9d2b3185b188a38df0188597a43e72e6813806421118ca00fd5030a5515ffad",
"pubkey": "7e9c924ae5255c95a454d28ae89552a1e081f828ad4dc0381508b509188c865e",
"created_at": 1763378342,
"kind": 1,
"tags": [
[
"e",
"a12ff3d33a94fa408d71e2435e6382700647f0cd3c0c09d56ec2cc64d5164b43",
"wss://ditto.pub/relay",
"root",
"76c71aae3a491f1d9eec47cba17e229cda4113a0bbb6e6ae1776d7643e29cafa"
],
[
"e",
"1250975a713b296652113231419ab243123fff2a767eb4f30cee3ec853b34117",
"wss://ditto.pub/relay",
"reply"
],
[
"p",
"d49a9023a21dba1b3c8306ca369bf3243d8b44b8f0b6d1196607f7b0990fa8df",
"wss://gleasonator.dev/relay"
],
[
"p",
"21856daf84c2e4e505290eb25e3083b0545b8c03ea97b89831117cff09fadf0d",
"wss://gleasonator.dev/relay"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"wss://gleasonator.dev/relay"
],
[
"p",
"fa984bd7dbb282f07e16e7ae87b26a2a7b9b90b7246a44771f0cf5ae58018f52",
"wss://gleasonator.dev/relay"
],
[
"p",
"3f770d65d3a764a9c5cb503ae123e62ec7598ad035d836e2a810f3877a745b24",
"wss://gleasonator.dev/relay"
],
[
"p",
"76c71aae3a491f1d9eec47cba17e229cda4113a0bbb6e6ae1776d7643e29cafa",
"wss://gleasonator.dev/relay"
],
[
"p",
"d0a1ffb8761b974cec4a3be8cbcb2e96a7090dcf465ffeac839aa4ca20c9a59e",
"wss://gleasonator.dev/relay"
],
[
"p",
"9fce3aea32b35637838fb45b75be32595742e16bb3e4742cc82bb3d50f9087e6",
"wss://gleasonator.dev/relay"
],
[
"p",
"781a1527055f74c1f70230f10384609b34548f8ab6a0a6caa74025827f9fdae5",
"wss://gleasonator.dev/relay"
],
[
"p",
"d2e97f7320554e1306951a7caebe0c5a962c464d151324ec960655b3ea9a4d1b",
"wss://gleasonator.dev/relay"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
],
[
"r",
"wss://nos.lol/"
],
[
"r",
"wss://nostr.wine/"
],
[
"r",
"wss://relay.damus.io/"
],
[
"r",
"wss://relay.primal.net/"
]
],
"content": "A proper SQLite database shouldn't have issues with this amount of traffic. D1 isn't just SQLite though, it's SQLite + an API.\n\nI would try using SQLite-in-DO instead of using D1. There's a good blog post about it here: https://blog.cloudflare.com/sqlite-in-durable-objects/\n\nSecondly I would look at splitting up the database into multiple databases.",
"sig": "c3917d4c0ee851026d45f7a85e95622203060c0d28cee47e65ea5cc944841757c92f3e9a03f7f6bd69548ffcbb03ef0793f81a0eb5264b0569df9bcdc07eae37"
}