The transient_cdr table is a poor work around to not having proper CDR retention logic in FreePBX. It holds the last 60 days of CDR records so the API and other queries don’t get bogged down by a massive CDR table.
Of course, if you need more than 60 days…you still have to do with a massive CDR table.