Simple answer here is your using the wrong tool for the job. Use the right API and you'll be golden.
It's okay, I know they were baited, but I sure bet you were surprised when I could show how you can get the same type of performance in a more versatile way (cross database capable) and that this functionality is not something inherently unique to IBM i.
-----Original Message-----
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Friday, September 06, 2013 1:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: How to handle Big Data under IBM i?
Matt,
Thank you for your response. I hope that neither you nor anyone else in this thread gets offended by the occasional baiting nature of some of my questions and comments. I really do hope to provoke thinking and discussion that helps all involved.
I wrote another benchmark. This time using Visual Foxpro to insert rows into the same "orders" table using the ODBC connector that comes with IBM i Access 7.1
http://pastebin.com/dPZ28t20
This interface required 22 seconds to insert 10,000 rows (455 rows per second). How would you account for the rather huge difference between this interface and the others we've been discussing?
I think that is a valid question because the majority of updates to most DBMS products from most applications occur through ODBC / JDBC interfaces.
-Nathan
----- Original Message -----
From: Matt Olson <Matt.Olson@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Sent: Friday, September 6, 2013 10:28 AM
Subject: RE: How to handle Big Data under IBM i?
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.
--
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,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
