Purging Data - Date Compression

RChurchill

Hi All,

Has anybody ever written their own purging routines to reduce the size of a database rather than use the built-in Date Compression routines?

If so, can you post your reasons for doing so?

Do you feel that the Date Compression routines are perfectly adequate?

A while ago a colleague wrote their own purging routine for Customer Ledger but I can't see much difference to the Date Compression alternative apart from obvious areas due to customisation within a database. :-k

Many Thanks

Robin

RChurchill

Hi Black Tiger,

That's the point I'm trying to find out - do the Date Compression routines work adequately especially if there are many customizations or is it best to write your own - maybe loosely based on the Date Compressions.

ara3n

The date compression routines work fine. To handle the customizations, it depends on what the customizatin is. If it's just fields on cust. ledger entry for example. they will be deleted, If it's additional table , it won't touch them.