AnsweredAssumed Answered

ODS_ Tables in the stats database

Question asked by dave.sharples on Aug 5, 2018
Latest reply on Aug 9, 2018 by fv0044365

Hi, a question about the ODS_ tables in the BBLEARN_stats database for those who are self hosted.

 

Does anyone do any data management on these tables in terms of removing rows to keep them small? They are the cause of some parts of our upgrades taking a long time due their size and the installer dropping constraints / indexes and then readding them each time it is run.

 

Tables such as:

 

ods_aa_content_activity

ods_aa_session_activity

ods_aa_course_activity

 

have over 50 million rows dating back to 2012 when we first installed Learn 9.1.

 

I'm hoping we can just delete the data from before the time we want, does anyone know the impact of doing so.

 

Thanks

Outcomes