{"id":1099,"date":"2011-08-06T07:21:12","date_gmt":"2011-08-06T05:21:12","guid":{"rendered":"http:\/\/www.switchbl8.nl\/blog\/?p=1099"},"modified":"2011-08-06T07:21:12","modified_gmt":"2011-08-06T05:21:12","slug":"dumping-data-very-fast","status":"publish","type":"post","link":"https:\/\/www.switchbl8.nl\/blog\/2011\/08\/dumping-data-very-fast\/","title":{"rendered":"Dumping data very fast"},"content":{"rendered":"<p><del datetime=\"2011-08-06T21:01:05+00:00\">Too bad my comment on the <a href=\"http:\/\/blog.transfer-solutions.com\/2011\/08\/dumping-data-very-fast\/\">original post<\/a> was deleted. Perhaps they don&#8217;t want to know what I had to say, or they don&#8217;t like C#? From the top of my head I wrote something like:<\/del><br \/>\nThe <a href=\"http:\/\/blog.transfer-solutions.com\/2011\/08\/dumping-data-very-fast\/\">original post<\/a>.<\/p>\n<p>I created a very simple C# implementation, a console application with hardcoded username\/password and select-statement. It roughly has the same speed as the Pro*C (C routine) version, about 1.7 million ALL_SOURCE records in about 57 seconds. C# is a little more appreciated amongst managers, since C# developers are a lot easier to hire than Pro*C developers. Why on earth you want to fiddle around with Java when something needs to be done fast, puzzles me. Even Java 6 (don&#8217;t know about 7 yet) does not come close to the performance of .NET, let alone natively compiling languages.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Too bad my comment on the original post was deleted. Perhaps they don&#8217;t want to know what I had to say, or they don&#8217;t like C#? From the top of my head I wrote something like: The original post. I created a very simple C# implementation, a console application with hardcoded username\/password and select-statement. It <a href='https:\/\/www.switchbl8.nl\/blog\/2011\/08\/dumping-data-very-fast\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[128,61,132,74],"class_list":["post-1099","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-c","tag-java-2","tag-oracle","tag-performance","category-1-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=1099"}],"version-history":[{"count":0,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1099\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=1099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=1099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=1099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}