Hi Geoff,

That sound like it might help me out as well.

Is there any chance you could pull that out and send it to me directly
as yahoogroups is behind the firewall here so I can't see it.

TIA
Paul

Geoff Worboys wrote:

>
> > With the current program with 7 program running which 3 was one
> > computer I managed to create 119 675 records in about 7minutes.
> > I am sure it can be bettered.
>
> Don has already pointed out some issues with the code.
>
> Even better use TIB_DSQL with parameterised insert.
>
> Back around mid-March, there was a lengthy discussion - including
> examples - about batch inserts (subject "Big Batch"). If you dont
> have your own archives check out
> http://groups.yahoo.com/group/IBObjects/files/ (you will have to sign
> in).
>
> If you cant get the archives and need some help just ask.
>
> Geoff Worboys
> Telesis Computing
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/