I just added this to my IBO test cases. It improves throughput by 30%.

Over the next few days I will add it to IBX and DBX test cases. When my GDS test case is done I will add it there also.

The drawback is that you lose the convenience and maintainability of referencing fields "by name".

----- Original Message -----
From: Alexander Tabakov
To: Daniel Rail
Sent: Monday, March 15, 2004 10:46 PM
Subject: Re[2]: [firebird-support] RE: At my wits end


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@...



------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]