At 10:09 PM 3/10/2007, you wrote:

>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

How do you manage to insert into a dataset that has RequestLive set
to False? Are you passing the insert parameters to an executable
stored procedure?

Helen