Subject Re: [firebird-support] RE: At my wits end
Author Nando Dessena
David,

<on accessing params by index>

D> I just added this to my IBO test cases. It improves throughput by 30%.
D> The drawback is that you lose the convenience and maintainability of referencing fields "by name".

You don't have to. Once the statement is prepared the references to
the TIB_Column or TParam objects are stable. Access them by name
outside the execution loop and store each in a local variable, then
access the local variables inside the execution loop.

I never access anything by index for clearness and ease of
maintenance.

Ciao
--
Nando Dessena
mailto:nandod@...