I’m 99% sure it’s this. You think these things are isolated, they are not.
Every time you load any server module, if any server module in the app is using:
from anvil.tables import app_tables
Then it is cashing every single one of the hundreds of tables in the app_tables object as table objects.
I am unsure how long or how much resources this actually takes.
I don’t want this to sound mean, I just don’t want you to waste any more of your time. In this post over a month ago, every person tried to convince you you should not build out so many tables this way and gave you other suggestions.
If this is causing the rest of your live app to have problems, you should find a way to save the work that you currently have, then revert to before you built this feature into your app so your users no longer have a bad experience.
(Maybe make a clone copy first so you don’t lose the table structures etc.)
You then need to rebuild this entire feature from scratch without using hundreds of tables, and re-launch it.
Of course this is all just my opinion, you don’t have to do anything you don’t want to.