> 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