Replying to Avatar powrespecter

Switched from postgres to sqlite for wss://powrelay.xyz

Much snappier now. Tried moving all the events but there might be a couple I missed, just rebroadcast if one of yours is missing 😅
Avatar
rejon 2y ago

wow surprising it’s faster. why?

Reply to this note

Please Login to reply.

Discussion

Avatar
powrespecter 2y ago

I think mostly because the db is small enough to fit in memory 😂

tbh I should have used sqlite from the start, but I'm new to databases

Avatar
rejon 2y ago

let’s see over time

Avatar
powrespecter 2y ago

wss://powrelay.xyz is designed to target a constant size

events with the least POW per byte are continuously discarded

Hopefully, that means it stays speedy