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

Hi, DbLoad and Load both use insert cursors. In general there is little to choose between them from a performance perspective. FET_BUF_SIZE does control the size of the cursor buffer for all these (from V7.1 onwards) and can help performance sometimes. HPL can be *much* faster than any of these. 10 Gb/h per CPU is easily achievable for simple loads with little conversion required. MMASHALK@ccsmtp.farinon.harris.com wrote: >.. > 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 ? -- ------------------------------------------------------------ Chris Jenkins, Advanced Technology Group, Informix Software Standard disclaimers apply