bi file growth

[longhair]

afternoonall,
progress 9.1c
hpux 11i
i have a db with 3 tables. 2 of which get wiped and repopulated at least once a day. db size is about 3mb.
whenever i delete the data from the table and create the new records bi file size grows to 6mb.
any suggestions on the below code, or db settings that may be causing this?

def var lead_part like zldtm.zitem.
def var lead_time as int.
def var lead_lead_soft as int.
def var lead_next_item like zldtm.zitem.
def var i as int no-undo.
def var j as int no-undo.

input from /files/filename.txt.
repeat transaction:
 do j = 1 to 100:
  lead_part = "".
  lead_time = 000.
  lead_lead_soft = 000.
  lead_next_item = "".
  import delimiter ";" lead_part lead_time
  lead_lead_soft lead_next_item.
     i = i + 1.
     if i modulo 100 = 0 then do:
      pause 1.
     end.
     create rcedi.zldtm.
     zldtm.zitem = lead_part.
     zldtm.zlead = lead_time.
     zldtm.zldifsft = lead_lead_soft.
     zldtm.zparent = lead_next_item.
    end.
   end.
input close.

thanks in advance.
regards,
longhair

 

[MDaanje]

Hello Longhair,

I don't see in your code where and how you delete the records. Can it be that your transaction scope is to big. Maybe your deleted records are thrown away after you have added records etc. This can result in bi-file growth.

I would suggest you narrow down your transaction scope, into several smaller scopes.