Subnostr

How much do we care about relay query speed vs note retention?

On a big aggregator like filter.nostr.wine, I could probably improve performance significantly by only serving the last 3 months of notes instead of our full history. Worth it?

Viktor Vsk 2y ago

It seems like it should be possible and pretty easy to achieve both:

- if one queries for a specific note, it shouldn’t depend on their amount

- if one queries for the events of last 3 months - it should use fast and small “latest 3 month events” index

- if one queries for older events or for not specified time range - it will be slower but still working

Or are you talking about some other use case?

Reply to this note

Please Login to reply.

Discussion

Mazin 2y ago

Has to do with overall size of the db and my ability to scale horizontally vs vertically.