Here's my 2 cents :))

So, as you already know your insert query must be prepared ONCE and
executed multiple times. You only have to bind parameter values for
each insert operation.

Here is my tip: When you set parameter values try to access params by
INDEX not by name. This way you will skip a lot of really nasty
parsing (at least in IBX).

--
Best regards,
Alexander mailto:saho@...