Re: Array Inserts

Im using array-inserts in Delphi 4.0 C/S. Say you want to insert 3000 rows, you fill your data in some arrays and pass these arrays as host-variables. So you only make one insert statement instead of machinegunning 3000 insert at the db!

In Delphi I must use variant-arrays, and in the example below each array MUST be of same length
INSERT INTO SAMPLE (SAMPLETIME, VALUE, METER_RECNUM) VALUES
 (:SAMPLETIME, :VALUE, :METER_RECNUM) Peter
ptl_at_edbgruppen.dk

Ming <fungs_at_logica.com> skrev i artiklen <7jqmmg$3r6_at_romeo.logica.co.uk>...
> First of all, thanks for the response to my SQL*Loader question.
>
> I've been told by certain parties that an Pro*C array insert maybe a
viable
> alturnative using a direct load. The problem is that a number of indexes
> need to be rebuilt after a load.
>
> Can anyone shed some light on what the array insert is, has any one used
the
> "direct-load" Insert ( not loader ) out there, is the performance
comparable
> to SQL*Loader.
>
>
>
Received on Fri Jun 11 1999 - 08:37:12 CDT