Subject Re: Re[2]: [firebird-support] RE: At my wits end
Author David Johnson
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:

b.. To unsubscribe from this group, send an email to:

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

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