Hi All
I Put 888.666 Rows, Reading from a Fixed Length Text file (96
MB) to my GDB approximately 40 Minutes by using a stored procedure and
using CommitRetaining every 10.000 records. This result satisfied me.

But the result below is UNBELIVEABLE!!

I'll try it also...

I wonder this

INSERT INTO SOME TABLE (TABLE_ID,AFILED1,AFIELD2) VALUES
(GEN_ID(SOME_GEN,1),XXX,XXX);
Is this Possible??

Burak

-----Original Message-----
From: Jason Frey [mailto:jason_frey@...]
Sent: Saturday, June 08, 2002 4:15 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Newbie Question -- Inserts slow?

> > Give the TIB_Transaction.ExecuteImmediate method a try. Of what I

see
in

> > the code there's no parsing and the statement is sent directly to

the

> > API. This might give you the speed you are looking for.

WOW.
I averaged between 320,000 and 330,000 records a minute.
That's much more than the speed I was looking for (I'm not arguing,
though
:)).
Thanks for the tip!

- Jason




________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/