We're at the point now where we need to decide what option to use for converting extractions during our upgrade. Whether to run the procedure UP_CLEAN_EXTRACTIONS with a date restriction, without one or at all.
For those who have done it, does truncating the whole mess (and that is one huge table) make extractions run any faster after the upgrade? Or is the advantage felt entirely during the actual upgrade process?
thanks,
Brian
Unknown said: For those who have done it, does truncating the whole mess (and that is one huge table) make extractions run any faster after the upgrade? Or is the advantage felt entirely during the actual upgrade process?
I don't think extractions are sped up at all by the move to v12, regardless of the number of rows in T_CUST_KEYCODE. Having tried this upgrade both with and without housekeeping that table, though, I can confirm that truncating it does indeed greatly speed up the migration itself.