Subject | Re: [firebird-support] RE: At my wits end |
---|---|
Author | Nando Dessena |
Post date | 2004-03-22T07:45:46Z |
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@...
<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@...