Search results

  1. R

    better way to delete 5millions rows

    Hi, thanks again for all coments. We are reviewing internally several things about the cause. We compiled the code and found into list there is no transaction indeed, because syntax ". and :", the use of "delete from", understanding the reason of delete all the rows, how long the bi increase...
  2. R

    better way to delete 5millions rows

    Hi Thomas, Thanks, for advice, we want to archive the old rows as history(before 2010). Thanks Tom, The -i option was saw at community.progress.com/s/article/P27293, and I agree not use. Agree, we have to use a transaction in the code. The code used from Developer was: FOR EACH...
  3. R

    better way to delete 5millions rows

    Hi, Looking for delete 5millions rows(50% of table), tryed using 4GL "delete where" the proccess exits with: [2024/11/24@00:53:26.491-0400] P-31364 T-0 F SRV 1: (854) ** Insufficient disk space to extend the before-image file, I already have 4 .bi files, then we add 3 .bi files...
Back
Top