Where can I find the 'optimized APIs for bulk data operations' documents?

[Anonymous]

I have seen it in wave2 document: https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/data-platform/use-optimized-...

We are very eager to use this feature to improve performance when some business logic need to do bulk update/insert.

I saw in October it should became public preview, but I can't find it anywhere. Can somebody help? Thanks in advance.

[GuidoPreite]

plugins have a timeout of 2 minutes, let's say you need to create100 records from the plugin, you can't know if they will be created under 2 minutes or not (for example these records can have sync plugins registered too), an executeMultiple also if works as expected probably will not solve this kind of issues. Plugins are meant for short transactions, working on records that require a "multiple" message usually is not.

[Anonymous]

Absolutely right now 100 records' creation should not be put in plugin, because they will executed in plugin one by one most likely it will hit 2mins timeout as you said. But if the creation requests can be concurrent executed as the document said, even 100 records will take few times then it can be inside a plugin reduce a lot of effort.

Plugin meant for short transactions that's the point I totally agree, but batch update a middle volume(10-100) of records should not be a long action, that' why I need a multiple message. 

[MattB-MSFT]

---

@Anonymous wrote:

executeMultiple is not supported in plugin, any request in plugin have to executed one by one.

---

for clarity sake,  ExecuteMultiple can be called from a plugin.   
I think your meaning to say "I cannot attach a plugin to the invocation of ExecuteMultiple",  that is correct, you cannot do that.  This is a lot to do with what ExecuteMultiple is designed to do and how it works in the SDK. ExecuteMultiple is a 'batch' concept where messages can be anything.

[Anonymous]

---

@MattB-MSFT wrote:

---

@Anonymous wrote:

executeMultiple is not supported in plugin, any request in plugin have to executed one by one.

---

for clarity sake,  ExecuteMultiple can be called from a plugin.   
I think your meaning to say "I cannot attach a plugin to the invocation of ExecuteMultiple",  that is correct, you cannot do that.  This is a lot to do with what ExecuteMultiple is designed to do and how it works in the SDK. ExecuteMultiple is a 'batch' concept where messages can be anything.

---

ExecuteMultiple is not supported inside a plugin, check this out:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/best-practices/business-logic/avoid-batch-requests-plugin?source=recommendations

I have struggled, tested for these stuff for a long time, the fact is the document is right. Even you can use ExecuteMultiple in plugin by force, the requests still not go into DB concurrently, as the document said, it has same effect of 

foreach (request in requests) service.Execute(request)

On the server side, the operations included in a batch request are executed sequentially and aren't done in parallel. 

Currently I cannot find one single way to do parallel DB actions inside a plugin, that's why I saw the new API as my savior.