tag:blogger.com,1999:blog-8884584404576003487.post5438011926539549004..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: To LOOP or Not to LOOPoraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8884584404576003487.post-78038242429206106742007-09-14T10:57:00.000-04:002007-09-14T10:57:00.000-04:00@APCIt's a pure PL/SQL environment. Our managemen...@APC<BR/><BR/>It's a pure PL/SQL environment. Our management (from one of our larger competitors) believes that with the volume of data we will be using PL/SQL will handle the load better. That said, we are soon to begin evaluating OWB. So who knows where it's going.<BR/><BR/>That's exactly what I'm going through at this time...it would be nice to see how a tool does it to understand some of the concepts behind it.<BR/><BR/>@jeff<BR/><BR/>That is the fun part, I agree. I guess that's why I love what I do.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-55461888573576972692007-09-14T07:02:00.000-04:002007-09-14T07:02:00.000-04:00Tom has it exactly right in my opinion.Whilst it c...Tom has it exactly right in my opinion.<BR/><BR/>Whilst it can take a bit more thought to do things in SQL, it's generally better when it comes to performance...and when you're dealing with warehouse type volumes then performance tends to be pretty important.<BR/><BR/>We had the same issues on the DW I look after, where a number of developers were rolled onto the project over time, often from OLTP PL/SQL backgrounds, and wanting to code things in a "slow by slow" fashion as you put it...trying to explain to them why the set based approach is better was hard work sometimes, but in the end they got it.<BR/><BR/>"Design Patterns" was one of the central approaches we instigated within our team and that worked well to ensure that we identified and tested set based approaches for achieving certain tasks, which we then ensured that all similar tasks<BR/>were coded according to the same design pattern.<BR/><BR/>I can't think of one case where we've had to resort to row based processing yet, although the flip side is that we've had to come up with some, sometimes convoluted, solutions just to keep it set based. <BR/><BR/>All good fun though.Jeff Mosshttps://www.blogger.com/profile/15168565894016993557noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-67343799964414931522007-09-14T04:30:00.000-04:002007-09-14T04:30:00.000-04:00Is there any reason why you're not using an ETL to...Is there any reason why you're not using an ETL tool to do this? <BR/><BR/>DW loader routines are hard to get, especially if you don't have any relevant previous in handling large volumes of data. This is the Voice of Experience. <BR/><BR/>Cheers, APCAPChttps://www.blogger.com/profile/18348719053445885097noreply@blogger.com