💡 Cycle schema hydration is too slow

[rauanmayemir]

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.