On Fri, 24 Oct 2003 21:05:23 +0000 (UTC), Yves Glodt wrote:

>> > we are trying to enhance performance of an application we
>> > resell. ...

> ...
> and then:
>
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 9, 145123, xxxxx);
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 10, 145123, xxxxx);
> repeat 20 times...
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 9, 145124, xxxxx);
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 10, 145124, xxxxx);
> repeat 20 times...
> etc
>

If you're doing it exactly like this you may be burdened by a 'prepare' for
each INSERT.


--
Aage J.