I have tried many variations of the commit. Every 10 records to every 10,000
records. I really did not notice an extreme difference. Slowest was 50 tps
and the peak is 300 tps. The execution of the stored procedure seems to
autocommit. Correct me if am wrong.

Edwin Epstein

> Continuity Partners Inc.
> 2753 S. Highland Dr.
> Suite 1010
> Las Vegas, Nevada 89109
> (702) 851-7850 Ext. 247
> eepstein@...
>

CONFIDENTIALITY NOTICE: The information contained in this message may be
privileged and confidential and protected from disclosure.
If the reader of this message is not the intended recipient, or an employee
or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer.




-----Original Message-----
From: Lee Jenkins [mailto:lee@...]
Sent: Monday, February 09, 2004 6:45 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] External File Construction


Epstein, Ed wrote:

> I appreciate the advice of switching platforms, no need to apologize at

all

> :)
>

No problem! Its just that I was in a similar situation, but wasn't as
pressed for time as you are now.

You probably already thought about this, but when you are using the ADO
layer, did it autocommit for you or were you doing a hard commit every
500-1000 records?

Sorry I couldn't be more help, I'm new to IB/FB myself :)

--

Warm Regards,

Lee




Yahoo! Groups Links