Does commit work (commiting the changess to database take same time for ..

[Former Member]

Does commit work (commiting the changess to database )take same time for one record and 1000 records

[Former Member]

I think there can be time difference in micro seconds

[Vijay]

hi,

it takes time but it won't be visible.

regards

vijay

[Former Member]

Hi ,

There is some micro seconds differences in updating the recors . If you have huge records ,split the data into parts and insert it .

To avoid errors or warnings ,you can use 'WAIT UPTO 5 SECONDS ' .

Thanks

Jagadeesh.G