I found out recently that our org is using ~85% of its data allocation. The number one offender for usage (13%) has no one looking at it. The number two offender for usage (7%) has no one looking at it. The number six offender...well, you get the idea. Just eyeballing it, I estimate we can lower our data consumption by at least 35%. I imagine that will have some impact on performance.
Does anyone already know if there is a well established effect on performance, and if so, what is it? Or stated as the converse, is there a known performance degradation as usage approaches the limit?
If the answer is not already known, I would like to test this hypothesis as we go about the process of eliminating so much data. Are there benchmarks I can run to evaluate performance before and after the purge? I can think of the following measurable indicators that may be affected:
Visualforce Pageload times
- Triggers, controllers, etc.
- Flow Engine
My main methodology when profiling code looks like the following:
Long start = Datetime.now().getTime(); // optional loop to increase granularity // operation to benchmark Long elapsedMs = Datetime.now().getTime() - start;
I'm not sure how I could adapt that to profile performance on batches and triggers. And I'm really not sure if it's possible to get a good picture of how flow performance is affected.
Do I stand to gain anything besides getting our instance more safely below the limit?