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
1 months agoRobt
11 days agoPedro
13 days agoTy
16 days agoNicolette
1 months agoMelvin
1 months agoFrancesco
1 months agoGlendora
16 days agoCarey
22 days agoSheridan
29 days agoNelida
2 months agoEdna
1 months agoLonny
1 months agoTamra
2 months agoReid
2 months agoNan
2 months ago