>At 03:30 PM 12/7/01 +0000, Ian Newby 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
> >('Key1','Data1'),
> >('Key2','Data2');
> >
> > I don't know if this is possible or even desirable, but it may be a
> >nice method of batch loading data.
> >

At 11:13 AM 12/7/2001 -0500, Jim Starkey wrote:

>Interest construct. Better than a series of individual "insert"
>statements by a long shot. But a better programmatic solution
>is to prepare one "insert" and execute it many times.

Actually, the multi-insert is a part of the SQL standard
and is more efficient since it's fewer round trips.


Regards,

Ann
www.ibphoenix.com
We have answers.