web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Import performance - c...

Microsoft Dynamics AX (Archived)

Import performance - csv vs xml

(0) Share

Report

Report

Posted on by Mariano Gracia

I have a question about performance with data management, I have to import several documents with header and lines, (about 240,000 lines), if I use a csv file then I will have to use two entities, one for the header and another one for the lines (and each line must contain the relation with the header), if I use xml I can use a composite entity which is, as I see, an ideal option for header and lines (in fact I have four tables in total) but I'm concern about performance, will be the process faster with csv?, or do I not have to be concerned about it?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Mariano Gracia,

You should not be concerned about performance because AX uses SSIS to push data from a file to a staging table and then AX comes into play to transfer data from staging to target table. SSIS is quite good with files and main time is spent on AX side anyway and it is not dependent on the file format.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Andrew Jones a1x 2

#3

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans