How’s TTL performance(Row level) in yugabyte?
How it affect when write/read at same time?
I’d like to know if there’s a a benchmark test especially for huge data?Or I need do it myself.
The case is that there’s always huge timeseries data came in we want the stale data auto move out (delete/move to other place).
TTL is one option. the other one is to split table by period(hour,day,week)
But with the latter, it may need run multiple query for a request.
Is there a good way to handle this? Look forward to your suggesstions.