Number of days that it is recommended to have in the PR_DATA_IH_FACT table and evaluate if it is possible to optimize the printing of NBA
Good morning,
Please, can you recomended the number of day that we need have in the table of interaction history PR_DATA_IH_FACT, in this moment we have the last year, but the quantity of impressión do that this table increase to varios GB.
The other point is, is possible that if the impressión of NBA return the same offer without change, not insert the new record?
Accepted Solution
Updated: 26 Jan 2024 11:34 EST
Pegasystems Inc.
US
@DENNYD14 , Its best practice not to use IH facts directly in your implementation and rather use IH Summaries. The use of summaries means that at runtime you never query IH fact directly and cause performance issues. Having said that, the insert performance into IH can get affected if your IH fact is too large and we recommend that your IH is no larger than your biggest IH summary window range. For example, if your largest summary is counts of times action was presented in last 90 days, then your IH should only hold 90 days worth of data in it so that if you ever need to re-populate IH summaries, you can always replay the last X days and build up IH summaries again.