Red Ogre Review on Nostr: npub15wawn…rezxc It might not be a quick fix, but spinning off older entries into ...
npub15wawnk00h6gfnwpkvx7p74cel8uy99tl9z6mdyhtt7lk2tcvptxq2rezxc (npub15wa…ezxc)
It might not be a quick fix, but spinning off older entries into their own quasi-archive tables could help, especially if they're ones that are rarely accessed. You'd need a routing mechanism somewhere to detect when to jump from the main table to the archives.
And do you have something like Redis in place for caching common / recent queries? That could help for material that's frequently accessed but doesn't change often.
It might not be a quick fix, but spinning off older entries into their own quasi-archive tables could help, especially if they're ones that are rarely accessed. You'd need a routing mechanism somewhere to detect when to jump from the main table to the archives.
And do you have something like Redis in place for caching common / recent queries? That could help for material that's frequently accessed but doesn't change often.