Use stored procedures

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of kokok_kokok
Sent: 03 October 2007 12:25
To: IBObjects@yahoogroups.com
Subject: [IBO] Optimize massive inserts with TClientDataSet + IBO

For a design question I need to dump a TClientData component with 3000
records in a database table. I use a combination of TClientDataSet +
TProvider + TIBOQuery

I found that it is really slow, it takes 2 minutes, I expected few
seconds.

I would like to know how I can optimize the TIBOQuery or other component.

Now, in the TIBOQuery I use:

Unidirectional=true
KeyLinksAutoDefine=false
KeyLinks="ID"
RequestLive=false


Thank you




___________________________________________________________________________
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 !
Yahoo! Groups Links




No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.39/1045 - Release Date: 02/10/2007
18:43


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.39/1045 - Release Date: 02/10/2007
18:43