Import huge amount of data

General
1

Hi,

I have to import a huge amount of data from an external source (>500k records).
When I do a loop with insertData() it takes quit long to import the data. While a bulk SQL insert script does this in minutes.

My question: Is it safe to do this via a sql script? The records I import are versioned and I have the fear, that I’m missing some data in preside later.

Any best practise advice here?

Thanks,
Michi

2

I don’t think it should be an issue. We already have provision for versioned tables with records that don’t have a corresponding version record - there is an option @versionOnInsert false which will only create a version record when the record is edited, but not on initial insert. But it should work fine event without that being set…