[PDB-3544] Fact Updating appears slower with Fact Reduplication Created: 2017/06/01 Updated: 2018/07/23 Resolved: 2017/06/12
|Affects Version/s:||PDB 4.4.0|
|Fix Version/s:||PDB 4.4.1|
|Reporter:||Nick Walker||Assignee:||Russell Mull|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
|Method Found:||Customer Feedback|
|QA Risk Assessment:||Needs Assessment|
I'm seeing an increase in time to update the facts table in PE 2017.2.1.
I'm also see a large increase in log messages where queries on the facts table are making temporary files.
That query has a plan like this:
I believe both of these plans can be improved with the following index.
CREATE INDEX facts_factset_id_fact_path_id_idx ON facts(factset_id, fact_path_id)
|Comment by Nick Walker [ 2017/06/01 ]|
On my test machine I'm noticing that it appears we make one update per fact changes which on my machine results in about 13 individual updates.
You can see that the 13 updates become significantly faster ( 2-4x faster) with the index:
|Comment by Nick Walker [ 2017/06/12 ]|
Russell Mull This was merged correct? Can you confirm the fix versions and close it?