|Subject||Re: [IB-Architect] SQL Scripts|
|Author||Ann W. Harrison|
>At 03:30 PM 12/7/01 +0000, Ian Newby wrote:At 11:13 AM 12/7/2001 -0500, Jim Starkey wrote:
> > As for the batch insert problem, one option for this would be to
> >implement a sort of batch insert, ie
> >INSERT INTO TEST (KEY,DATA) VAlUES
> > I don't know if this is possible or even desirable, but it may be a
> >nice method of batch loading data.
>Interest construct. Better than a series of individual "insert"Actually, the multi-insert is a part of the SQL standard
>statements by a long shot. But a better programmatic solution
>is to prepare one "insert" and execute it many times.
and is more efficient since it's fewer round trips.
We have answers.