It's hard for me. I'm using pg as my relay database now, most of the time it's fast, but some queries are slow because it doesn't choose the best index. I'm trying to learn and try to optimize 🧑💻
Discussion
Exactly. Yesterday I had to solve similar problem with nostr.build shitty MySQL DB. We had one query that too 3 seconds to execute on a short hardware. After looking deeply into it and removing, adding a few indexes and changing the query, I got the same result in 200ms and with much less response consumption 🐶🐾🫡