Yes - I could see that the logic of getting the "DIR" would at least be reduced by the number of records being deleted and already in a list -- I mean, if I'm deleting after 30 days, today I would *know* what records are being deleted for the next 29 days at least. It would make the nightly/daily process shorter...
While this is more efficient - it would be a bunch of extra logic and 'Save-Lists' that had to be kept correct - and if the process were not run 'daily' you'd have to have a 'catch-up' mechanism to walk back to the last day a list *did* exist ... This would likely be ideal if we ran the process during 'PrimeTime' -- Thanks!! (But just the idea of using SaveLists just reminded me I likely also have abandoned SaveLists to try and figure out what can be nuked -- and we don't even have a "DIR" function we can use there!! Argh!! Or I could just have them buy more disk space... Hmmmm... Which would actually be easier...) ;-) DW > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee > Sent: Wednesday, January 09, 2008 6:49 PM > To: [email protected] > Subject: RE: [U2] [UD] Cleaning out _PH_ > > David, > > This will take time to settle to a time where it will > function correctly. But here is my suggestion - Day 1 - save > a SELECT list of _PH_ using the date of day 1 as part of the key. > Day 2-30 - do the same, but remove from list the contents of > the previous day's list Day 31 - delete everything in Day 1 > saved list, make a new list as per Day 2. > Day 32 onwards - delete what is in the list for 30 days ago. > Make a new list as per Day 2. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
