I had not thought of by index. I will try that and see what kind of
performance increase I get.

Edwin Epstein
Continuity Partners Inc.
(702) 851-7850 Ext. 247
eepstein@...

Confidentiality Note: This e-mail, and any attachment to it, contains
privileged and confidential information intended only for the use of the
individual(s) or entity named on the e-mail. If the reader of this e-mail is
not the intended recipient, or the employee or agent responsible for
delivering it to the intended recipient, you are hereby notified that
reading this e-mail is strictly prohibited. If you have received this e-mail
in error, please immediately return it to the sender and delete it from your
system.

This e-mail and any attachment(s) are believed to be free from virus.
However it is the responsibility of the recipient to insure that they are
virus free. We do not accept any liability for any loss or damage arising in
any way from the receipt, opening or use of this e-mail and any
attachment(s). Thank You.



-----Original Message-----
From: David Johnson [mailto:d_johnson@...]
Sent: Thursday, March 18, 2004 12:17 AM
To: firebird-support@yahoogroups.com
Subject: Re: Re[2]: [firebird-support] RE: At my wits end


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]




Yahoo! Groups Links