I'm Will, building Usero (a feedback tool) solo, just got back to Sydney after 5 years away. I built it for my own projects, having built a smaller version of it on every project I started.
Sending feedback from one of my other apps was way too slow in Sydney, and it turned out to be the distance between the Cloudflare worker in Singapore and the D1 database in the US, about 250ms per query, 6 in a row. Since Prisma can't batch on D1, I had to fix it with fewer queries, Promise.all, and waitUntil. Thought I'd share here, "feedback" welcome
willsmith72•8m ago
Sending feedback from one of my other apps was way too slow in Sydney, and it turned out to be the distance between the Cloudflare worker in Singapore and the D1 database in the US, about 250ms per query, 6 in a row. Since Prisma can't batch on D1, I had to fix it with fewer queries, Promise.all, and waitUntil. Thought I'd share here, "feedback" welcome