I’m trying to find ways to improve performance of my app and one of the bottlenecks is searching the sqlt_core table to find the right row to update. I’m wondering if I can add a foreign_key column without messing up the works.
I have a few other things to try first.