Federated search performs poorly when queries require frequent large joins across sources, because network round-trips dominate execution time and a pre-joined materialized dataset wins on latency and cost. It also struggles when source systems cannot absorb additional query load from a federation layer on top of their normal workload. In those scenarios, purpose-built centralized storage with pre-aggregated data delivers better price-performance.