I use pb ImportFile () function, import a 100000 data XML file (400 m), stored in the MS is essentially, but the speed is too slow, about 2-3 hours,
I think the reason is: the function first to fully open the XML file, and then to read a detailed data window (memory), and then submit it to the database, obviously the memory is too big, the speed is slow,

Consult prawns, have what good solution can greatly improve the speed?

CodePudding user response:

If you use this function, it should be no way to optimize the
Can consider fileread after inserting data window or database
However, the speed can be faster it's hard to say,

CodePudding user response:

Long dwcontrol. ImportFile ({saveastype importtype}, string filename {, long while the startrow {, long endrow {, long startcolumn {, long endcolumn {, long dwstartcolumn}}}}})

Lines can set the starting and ending,
You have 2 computer, a do 1 to 50000
Another 50001 to finish,
At the same time, speed immediately lift 1 times...

CodePudding user response:

I don't know, to help

CodePudding user response:

There is a problem please GOOGLE and BAIDU