On Tue, 2003-02-25 at 03:59, Christoph Haller wrote:
> for (CmdIndex = start_index; CmdIndex < nRows; CmdIndex++)
> {
> sprintf(CmdLine,
> "INSERT INTO AArray_Values ( Primary_Key, List_Pointer,\
>Parameter_Name, Parameter_Code,\
> Dim_Pointer, File_Pointer, Source_Type )\
>
> On Mon, 2003-02-24 at 07:22, Christoph Haller wrote:
> > I've noticed subsequent executions of the same insert command are
slow.
> > I've searched the list archives for this matter and found several
> > entries
> > related, including suggestions how to speed up.
> > The standard answer from the
>
> > The key word REPEATED directs INGRES to encode the INSERT and save
its
> > execution plan when it is first executed. This encoding can account
for
> > significant performance improvements on subsequent executions of the
> > same INSERT.
>
> > What do you others think of it?
>
> You can do th
On Mon, 2003-02-24 at 07:22, Christoph Haller wrote:
> I've noticed subsequent executions of the same insert command are slow.
> I've searched the list archives for this matter and found several
> entries
> related, including suggestions how to speed up.
> The standard answer from the core team is,
Christoph Haller <[EMAIL PROTECTED]> writes:
> Taken from the Reference Manual
> [REPEATED] INSERT INTO ...
> The key word REPEATED directs INGRES to encode the INSERT and save its
> execution plan when it is first executed. This encoding can account for
> significant performance improvements on s
I've noticed subsequent executions of the same insert command are slow.
I've searched the list archives for this matter and found several
entries
related, including suggestions how to speed up.
The standard answer from the core team is, use COPY.
Sorry, but this is from an application point of vie
