Hi,
to the first question, it takes 2 seconds.
To the other question, I'm testing, and return sooner with the answer
i'm testing with this code:
DECLARE @X XML
SELECT @X = CAST(x AS XML)
FROM OPENROWSET(
BULK 'C:\temp\teste.xml',
SINGLE_BLOB) AS T(x)
INSERT INTO OSUSR_DFP_PEP_ENTITIES (ENT_ID, NAME, FIRSTNAME, LASTNAME, PREFIX, SUFFIX,
AKA, NAMESOURCE, PARENTID, GOVDESIGNATION, ENTRYTYPE, ENTRYCATEGORY, ENTRYSUBCATEGORY,
ORGANIZATION, POSITIONS, REMARKS, DOB, POB, COUNTRY, EXPIRATIONDATE, EFFECTIVEDATE,
PICTUREFILE, LINKEDTO, RELATED_ID, SOURCEWEBLINK, TOUCHDATE, DIRECTID, PASSPORTID,
NATIONALID, OTHERID, DOB2, ENTLEVEL, MASTERID, WATCH, RELATIONSHIPS)
SELECT X.product.query('Ent_ID').value('(./text())[1]', 'INT'),
X.product.query('Name').value('(./text())[1]', 'nvarchar(1000)'),
X.product.query('FirstName').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('LastName').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Prefix').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Suffix').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Aka').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('NameSource').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('ParentID').value('(./text())[1]', 'INT'),
X.product.query('GovDesignation').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('EntryType').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('EntryCategory').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('EntrySubCategory').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Organization').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Positions').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Remarks').value('(./text())[1]', 'nvarchar(max)'),
X.product.query('DOB').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('POB').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Country').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('ExpirationDate').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('EffectiveDate').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('PictureFile').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('LinkedTo').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('Related_ID').value('(./text())[1]', 'INT'),
X.product.query('SourceWebLink').value('(./text())[1]', 'nvarchar(max)'),
X.product.query('TouchDate').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('DirectID').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('PassportID').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('NationalID').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('OtherID').value('(./text())[1]', 'nvarchar(50)'),
X.product.query('DOB2').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('EntLevel').value('(./text())[1]', 'nvarchar(500)'),
X.product.query('MasterID').value('(./text())[1]', 'int'),
X.product.query('Watch').value('(./text())[1]', 'bit'),
X.product.query('Relationships').value('(./text())[1]', 'bit')
FROM @X.nodes('Export/Entities') AS X(product);