topic Re: Commit to release memory in Application Development and Automation Discussions

Commit to release memory

Former Member — Thu, 06 Jul 2006 17:30:58 GMT

Hi All,

I have a program that updates an infostructure from another by collecting based on certain criteria. But my source has around 2 Million records and uses up a lot of memory. How can i commit the update lets say, for every 25000 records.

And does that release the memory.

Thanks in advance.

Re: Commit to release memory

Former Member — Thu, 06 Jul 2006 17:36:26 GMT

hi,

do not update all the records at a time. split them into 5000 records something like that and update the database.

hope this help.

sorry i have understood it differently.

sudheer.A

Message was edited by: sudheer Addepalli

Re: Commit to release memory

Former Member — Thu, 06 Jul 2006 17:38:38 GMT

Well you can use "commit work and wait" statement after each 5000 record. put a counter and inside the if condition use above command.

Re: Commit to release memory

Former Member — Thu, 06 Jul 2006 17:39:16 GMT

Gather from the source in smaller chunks (like 25000) and commit the update. Then clear/refresh the internal table.

This will limit the internal table to a byte size of (25000) times (width of record).

Internal table size = number of record X record width

Re: Commit to release memory

Former Member — Thu, 06 Jul 2006 19:59:38 GMT

Hi,

I have to modify like in the code below.

And how can i commit for every 25000 records when the situation is as below.


  modify s701 from table it_s701 .
  if sy-subrc eq 0.
    ws_dbcnt = ws_dbcnt + sy-dbcnt.
  endif.

  modify s701 from table it_zdrr.
  if sy-subrc eq 0.
    ws_dbcnt = ws_dbcnt + sy-dbcnt.
  endif.

  modify s701 from table it_zrep.
  if sy-subrc eq 0.
    ws_dbcnt = ws_dbcnt + sy-dbcnt.
  endif.

Thanks again..!

Re: Commit to release memory

Laxmana_Appana_ — Thu, 06 Jul 2006 20:03:08 GMT

Hi,

Check this :

if ws_dbcnt = 25000 .

commit work and wait

endif.

if you are inside the loop , at the end use commit work.

AT LAST.

COMMIT WORK.

Laxman

Re: Commit to release memory

Former Member — Thu, 06 Jul 2006 20:12:34 GMT

Hi Laxman,

But, i wouldn't get the ws_dbcnt untill i get the whole Internal table updated to the DB table. so if it has a million records, i would still be losing on memory.

And i'm not looping in the internal table here, so i can't use the second option either.

Is there any other way to do this ?

Thanks again..!

Re: Commit to release memory

Laxmana_Appana_ — Thu, 06 Jul 2006 20:18:55 GMT

hi,

Then use 'commit work and wait' after every modify statement.

try this.

Laxman

Re: Commit to release memory

Former Member — Thu, 06 Jul 2006 20:23:18 GMT

Use "Commit work and Wait" as i mentioned earlier. it will solve your problem.