[idea] a new page all about Fusion' Caching

### What's your idea for new content?

A page all about how Fusion does caching.

non-exhaustive list of caching:
- source schema cache
- relation cache
- LSP's compile cache
- query cache

####

current relational docs info that I can find
- [Reference: Global Configs: Cache](https://docs.getdbt.com/reference/global-configs/cache#cache-population) https://github.com/dbt-labs/docs.getdbt.com/blob/c43c1950f3114b30910b1d281c021c1c13573700/website/docs/reference/global-configs/cache.md?plain=1#L9
- [Reference: Available Flags: Logs: Logging relational cache events](https://docs.getdbt.com/reference/global-configs/logs#logging-relational-cache-events)

### Where would you recommend this content live on the docs.getdbt.com?

somewhere within the new Fusion docs section (#8045)