Milan wrote:

> Beside limit of size of SQL statement there's also the limit of compiled
> SQL statement in BLR form. In cases like this I usually group about 100
> inserts in single EXECUTE BLOCK and then run those in batches.

Which brings me to another aspect of the original question. If many of the
statements are the same, only with different parameters, e.g.:

insert into MyTable (a, b, c) values (3, 4, 5);
insert into MyTable (a, b, c) values (8, 9, 9);
insert into MyTable (a, b, c) values (-3, 0, 6);

I'd rather prepare it as a parameterised statement and execute it as many
times as needed, filling in the values before each execution. A lot more
efficient, methinks, and probably also quicker.


Paul Vinkenoog