Re: Light Appends
}>From ilist@rmy.emory.edu Mon Jun 16 10:51:01 1997
}>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO)
}> for <settler@dbintellect.com> id KAA09901; Mon, 16 Jun 1997 10:50:04 -0600
}>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id KAA11057 for informix-list-out; Mon, 16 Jun 1997 10:45:02 -0400 (EDT)
}>Message-ID: <01BC7A69.277A6A20@limehouse.twowaytv.co.uk>
}>From: Manoj <manoj@mailhost.twowaytv.co.uk>
}>To: "'informix-list@rmy.emory.edu'" <informix-list@rmy.emory.edu>
}>Subject: Light Appends
}>Date: Mon, 16 Jun 1997 15:22:49 +0100
}>MIME-Version: 1.0
}>Content-Type: text/plain; charset="us-ascii"
}>Content-Transfer-Encoding: 7bit
}>Sender: informix-list-owner@rmy.emory.edu
}>Reply-To: Manoj <manoj@mailhost.twowaytv.co.uk>
}>X-Informix-List-Id: <list.14998>
}>
}>Does anyone know what light appends are (onstat -a).
}>
}>Thanks,
}>
}> Manoj Schroff, Two Way TV Ltd, UK
}> +44(0)181 996 8221
}> manoj@mailhost.twowaytv.co.uk
}> http://www.twowaytv.co.uk
}>
}>
My understanding is that they are the insert equivalent of the
light scan select. I see them when I am executing a High-Performance
Loader job to load rows into a table (onstat -g lap). I believe
light appends are inserts that do not have to go through the buffer
pool.
-------------------------------------------------------------------
Jeff Craig | dbINTELLECT Technologies, Inc.
Senior Consultant | Golden, CO
| (303) 275-6954 ext. 8008
| email: settler@dbintellect.com
| fax: (303) 275-2134
-------------------------------------------------------------------