I’m rewriting how my ORM, Nymph.js handles access controls. Right now, it stores the access control vars (user, group, permissions) in the same table as all of the other data, which makes the full text search slow because it has to join the tables multiple times. I’m moving those access controls into the entity tables where all the joins start from, so a simple index can handle that before it even joins the FTS tokens table.
The hard part is going to be migrating existing data in my email service that uses Nymph. It’ll be multiple steps: create the new columns, make sure new entities add that data to both the new columns and the old way, migrate all entities to have the data in both, update the queries to use the new columns and stop storing data the old way, then delete all the old data. It’ll be the opposite of fun, but hopefully once I’m done it’ll be way faster.