{"id":9,"date":"2006-05-14T15:55:53","date_gmt":"2006-05-14T15:55:53","guid":{"rendered":"http:\/\/etlguru.com\/blog\/2006\/05\/14\/what-etl-performance-processing-speed-is-good-enough\/"},"modified":"2006-05-14T15:55:53","modified_gmt":"2006-05-14T15:55:53","slug":"what-etl-performance-processing-speed-is-good-enough","status":"publish","type":"post","link":"https:\/\/etlguru.com\/?p=9","title":{"rendered":"What ETL performance (processing speed) is good enough?"},"content":{"rendered":"<p>Every ETL developer \/ Data Warehouse Manager wants to know if the ETL processing speed\u00c2\u00a0 (Usually measured in NUMBER OF ROWS PROCESSED PER SECOND on target side)is good enough? What is the industry standard? I can give a politically correct answer like\u00e2\u20ac\u00a6 Well it depends\u00e2\u20ac\u00a6\u00c2\u00a0<\/p>\n<p>But I would rather be blunt and say that usually for INSERTs, 1000\u00c2\u00a0and for UPDATEs 300 rows\/sec should be good enough. If you don\u00e2\u20ac\u2122t have special requirements then any average around these numbers should make you comfortable.\u00c2\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Every ETL developer \/ Data Warehouse Manager wants to know if the ETL processing speed\u00c2\u00a0 (Usually measured in NUMBER OF ROWS PROCESSED PER SECOND on target side)is good enough? What is the industry standard? I can give a politically correct answer like\u00e2\u20ac\u00a6 Well it depends\u00e2\u20ac\u00a6\u00c2\u00a0 But I would rather be blunt and say that usually [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3,8,1],"tags":[],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-database-tuning","category-etl-performance-tuning","category-informatica","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9"}],"version-history":[{"count":0,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/9\/revisions"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}