Enabling Update Batching in ADF

Tweet about this on TwitterShare on Facebook6Share on LinkedIn3Share on Google+0

To improve the performance of an application that performs many DML (INSERT, UPDATE, DELETE) operations per transaction, you can enable the Update Batching. For example, if you have to perform three updates before transaction commit, instead of you perform three DML statements (3 UPDATES), you can use Update Batching to execute only one bulk update statement that handles all three updates. You can use Update Batching with INSERT and DELETE too.

In this post I will show how to enable Use Update Batching option and I will perform some DML statements too.

In the Applications window, double-click Employees Entity.
In the Overview editor, click the Generic navigation tab and then expand the Tuning section.
Just select the Use Update Batching option, do not change the number of entities modified.

how-to-use-update-batching-in-adf1

Just like that!
Save everything and run the Oracle ADF Model Tester.

INSERT

Create three employees and click Commit.

Normal:

how-to-use-update-batching-in-adf2

Using Update Batching:

how-to-use-update-batching-in-adf3

UPDATE

Update three employees and click Commit.

Normal:

how-to-use-update-batching-in-adf4

Using Update Batching:

how-to-use-update-batching-in-adf5

DELETE

Delete three employees and click Commit.

Normal:

how-to-use-update-batching-in-adf6

Using Update Batching:

how-to-use-update-batching-in-adf7

Exceptions

The Update Batching is disabled if the entity object has attributes of BLOB or CLOB type or if the entity object has attributes that are set to Refresh After Insert or Refresh After Update.

Tweet about this on TwitterShare on Facebook6Share on LinkedIn3Share on Google+0

Author: Waslley Souza

Consultor Oracle com foco em tecnologias Oracle Fusion Middleware e SOA. Certificado Oracle WebCenter Portal, Oracle ADF e Java.

Leave a Reply

Your email address will not be published. Required fields are marked *