BYOD Export not parallel?

(0) Share

Report

Posted on by agneum

150

I have a batch job to export to some tables to my Azure SQL server.

However, when the job is run it only exports one entity at a time. Very painful and slow. Why is this? Is there any way to make it run in paralell?

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

nmaenpaa 101,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

Did you put all entities in one batch job?

I suggest you set up one batch job for one entity. This way the system can process multiple exports in parallel.

Was this reply helpful? Yes No
agneum 150 on at

Like (1)

Report
Copy link

Link copied!

Yes, I put them all in one batch job and set "Run sequentially" parameter to "off". The article says "If entities don’t have any functional dependencies, they can be scheduled for parallel import or export.". I got confused on that.

If there is any other way than running seperate batch jobs per entity please let me know, otherwise I will do that instead.

docs.microsoft.com/.../data-import-export-job

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report
Copy link

Link copied!

Hi Agneum,

Functional dependencies limit their export order, so we need to confirm the sorting in advance, if not, they will run in parallel without order.

When you select one or more entities, and then select publish , a batch job is started.

Was this reply helpful? Yes No