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