parttime Admin
New Member
I'm faced with a similar challenge (1TB and ever growing) .
My main motivation for compacting is to reduce downtime for future version changes, backups, transfers etc.
I have lots of historic data and would be fine to have a separate archive db for lookup of old data (say older then 5 yrs).
My idea is to do a "dump specified" of recent data then load into an empty db copy.
Cutoff recids for each of the relevant large tables (around 20) are manually chosen.
* most of the recids are deduced from one master table using direct relations
like first order of 2020/1/1 and eg. oldest shipment where shipment.order >= that order.
* some tables have no direct connection (or one that is unresolvable with a reasonable performing query ) and therefore the pivot index is just a date cutoff.
* The smaller tables (hundreds) are dumped completely.
Did this once followed by an idx rebuild. Could start the db but crashed little later when purging some static data from within the application.
Since i'm only part-time admin this was my last attempt so far but this thread reminded of getting this done.
Sorry for not providing any helpful input to the thread, but it helped me sort my thoughts and getting into it again
regards,
PTA
My main motivation for compacting is to reduce downtime for future version changes, backups, transfers etc.
I have lots of historic data and would be fine to have a separate archive db for lookup of old data (say older then 5 yrs).
My idea is to do a "dump specified" of recent data then load into an empty db copy.
Cutoff recids for each of the relevant large tables (around 20) are manually chosen.
* most of the recids are deduced from one master table using direct relations
like first order of 2020/1/1 and eg. oldest shipment where shipment.order >= that order.
* some tables have no direct connection (or one that is unresolvable with a reasonable performing query ) and therefore the pivot index is just a date cutoff.
* The smaller tables (hundreds) are dumped completely.
Did this once followed by an idx rebuild. Could start the db but crashed little later when purging some static data from within the application.
Since i'm only part-time admin this was my last attempt so far but this thread reminded of getting this done.
Sorry for not providing any helpful input to the thread, but it helped me sort my thoughts and getting into it again
regards,
PTA
