💡 Cycle schema hydration is too slow
rauanmayemir opened this issue · 0 comments
rauanmayemir commented
I have an idea!
Currently, spiral/roadrunner app bootstrapping is very slow, it takes a pod at least 1 minute to become ready, part of which is cycle fetching information_schema data and setting up its schema. I wish it were faster.
Upon debug dumping queries, I noticed that the data is not cached in any way, so information_schema is queried over and over again.
If I were to connect to a DB that is far from the app (say, there is a 60-100ms latency), then the app wouldn't be able to boot itself at all in reasonable time frame.