Wait, so the CRM data stream is creating a row for every lead and opportunity, daily? That's like a million rows a day! No wonder the dashboard is sluggish - the poor server must be gasping for air!
D) The data is stored at the workspace level - oh, that's a good one. If the data is not partitioned or optimized for querying, that could definitely slow things down. Workspace-level storage is probably not the best choice for a CRM data stream.
I'm surprised option A) is even an option. Creating a complementary data stream type automatically? That sounds like a recipe for disaster, not a reason for performance issues!
C) No mappable measurements - all measurements are calculated - that's an interesting point. If there are no pre-calculated metrics and everything needs to be computed on the fly, that could definitely impact performance.
C) No mappable measurements - all measurements are calculated - that's an interesting point. If there are no pre-calculated metrics and everything needs to be computed on the fly, that could definitely impact performance.
B) Pacing - daily rows are being created for every lead and opportunity keys - that seems like a reasonable explanation for performance issues. The constantly growing data volume could definitely slow down the dashboard loading.
Lashon
2 months agoRobt
25 days agoPedro
27 days agoTy
1 months agoNicolette
2 months agoMelvin
2 months agoFrancesco
2 months agoGlendora
1 months agoCarey
1 months agoSheridan
1 months agoNelida
3 months agoEdna
2 months agoLonny
2 months agoTamra
3 months agoReid
3 months agoNan
3 months ago