commit after 1000 records

[jovery]

Add a counter

counter := 0

insert ...
counter := counter + 1
if counter = 1000 then
  commit;
  counter := 0;
end if;