Forum BigDB BigDb maintenance

Discussion and help relating to the PlayerIO database solution, BigDB.

BigDb maintenance

Postby Jvillar » February 10th, 2021, 4:51 pm

Hi,
I would like to know if there is any way to configure a table so that all the elements are eliminated every certain period of time (week/ month) or do I have to make an external call to the database to remove all the entries before a specific date.

Thank you,
Javier Villar Zarza
Jvillar
 
Posts: 2
Joined: March 23rd, 2020, 12:12 pm

Re: BigDb maintenance

Postby Henrik » March 6th, 2021, 3:06 am

Hey Javier,

No, there's no automatic "time to live" or similar functionality in BigDB. We advice you to have an index on a DateTime field, and then have a cleanup script calling DeleteRange on that index.
Henrik
.IO
 
Posts: 1880
Joined: January 4th, 2010, 1:53 pm

Re: BigDb maintenance

Postby Jvillar » March 8th, 2021, 8:50 am

ok,
that works, thanks
Jvillar
 
Posts: 2
Joined: March 23rd, 2020, 12:12 pm


Return to BigDB