I have a large XML file and I use bulk load for taking it. The sample of my file is like this:
<Root Parts="Mypart"> . . <part number="100000"> <PT pt1="1" pt2="2" ... pt5="5"/> <PT pt6="6" pt7="7" ... pt9="9"/> </part> . . </Root> Because I need to save attributes of parts and also number of them and I use ../../ to fetch numbers of part. My output in SQL table is like below:
100000 1 2 3 4 5 100000 6 7 8 9 it's performance is not good. Is there any way to increase it? Thanks.
No comments:
Post a Comment