You’re offline. This is a read only version of the page.
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)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.
Share
Report
All responses (
Answers (
60,284
