Another thing, this BulkUploadToSQL utility is part of the .NET framework (built-in library), but it's specifically designed for Microsoft SQL Server. For MySQL you use MySqlBulkLoader, for oracle you use the OracleBulkCopy namespace / classes.
As you can see, these fast results are available in .NET, purely object oriented programming language and is interoperable with many database types. Whereas your DDS and RPG example is good for... DB2 on i only.
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Friday, September 06, 2013 11:03 AM
To: Midrange Systems Technical Discussion
Subject: Re: How to handle Big Data under IBM i?
From: Matt Olson
Did a quick test after hours.
Thanks for taking the time to create, run, and share a benchmark program. This looks like useful information. I gather that BulkUploadToSql is a utility of MS SQL Server which is NOT available under IBM i or any other DBMS?
My test completed in 335 seconds ...
Your main program uses 2 Stopwatch components. Could you share the elapsed time for both?
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l