topic Re: Modify Statement takes longer time in Application Development and Automation Discussions

Modify Statement takes longer time

Former Member — Wed, 11 Aug 2010 09:09:24 GMT

Hi ,

I am modifying database from an internal table.

MODIFY data_base FROM TABLE it_table.

It takes long time and gets a dump with time out error. Even The table it_table contains less number of records the program gets stuck in this statement.

Please suggest what should be done.

Re: Modify Statement takes longer time

Sandeep_Panghal — Wed, 11 Aug 2010 09:23:26 GMT

try modifying only record and check the time, also check DB locks in DB01 txn.

Re: Modify Statement takes longer time

Former Member — Wed, 11 Aug 2010 09:26:53 GMT

Even for single record it is the same.

Re: Modify Statement takes longer time

Sandeep_Panghal — Wed, 11 Aug 2010 09:31:44 GMT

then contact your system admin and find out if there are any perf. issues wiith the UPD work process

Re: Modify Statement takes longer time

kesavadas_thekkillath — Wed, 11 Aug 2010 10:01:49 GMT

no of records in it_table ???

Re: Modify Statement takes longer time

Former Member — Wed, 11 Aug 2010 10:19:17 GMT

Hi,

If you are just trying to modify the existing records means try UPDATE statement.