Tell me which takes less CPU time

harishch_ch · New User Joined: 07 Jan 2008 Posts: 27 Location: bangalore

Hi,

I got 100 records with my query,
Tell me which takes less CPU time?

1) Commiting ( uPdating/Deleting etc) all 100 at a time.

2) Commiting 50 once and 50 then.

Plz give a quick response.

thanks
Hari.

raviprasath_kp · New User Joined: 20 Feb 2005 Posts: 65 Location: chennai

may be the first one only

dick scherrer · Posted: Fri Apr 04, 2008 7:44 pm

Hello,

anjani shanker · New User Joined: 26 Jan 2007 Posts: 37 Location: USA

Committing does increase the run time for pgm to some extent...but keeping the updates waiting for commit means you are increasing the entries in buffer (logfiles) which is a very unefficient way to code.

Its better that u code like update 50 and commit them...rather than update all and then commit all....

I think the first one would that less time of 2 u mentioned...Plz correct me if I am wrong

dick scherrer · Posted: Fri Apr 04, 2008 9:04 pm

Hello,

ashok_uddaraju · New User Joined: 21 Feb 2007 Posts: 72 Location: US

Probably 100 is not large number so it does not make any difference on 1 commit or 2 commits, but when data is too alrge we better go for 2 commits

harishch_ch · New User Joined: 07 Jan 2008 Posts: 27 Location: bangalore

From the above replies, i understand that commit doesnot make any difference in cpu time , correct me if i am wrog:)

Craq Giegerich · Posted: Thu Apr 10, 2008 9:22 pm

The number of commits would make a difference in the CPU time, but that should not be the only reason for determining the number or frequency of the commits.