Re: Insert Cursors v/s DbLoad v/s Load

MMASHALK@ccsmtp.farinon.harris.com wrote: > > Hi All, > > I have a question which has been bothering me for quite some time now. > Which is faster: Insert Cursor or DbLoad or Load ?? > > Could inserts using Insert cursor be made faster by increasing > FET_BUFSIZE or other(??) parameters ? Similarly is there any way to > make dbload faster (like -k option) ? Can Load be made faster ? > > I am also keen on hearing responses from people who have actually > selected one over the other, and to what effect. > > One assumption is that Load is the slowest of the lot ? How true is > the assumption. > > Last but not least how does HPL compare to all of the above ? > > > TIA > > Max I don't know about dbload, but onpload screams. It rips. Major speed. Insert cursors have their place, but if you're just trying to do a mass load of data this would be the long way home. Use onpload, and marvel. A great product. :-) -- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) ------------------------oOOo---( )---o00o--------- http://www.inxutil.com