Subject | Optimize massive inserts with TClientDataSet + IBO |
---|---|
Author | kokok_kokok |
Post date | 2007-10-03T11:24:30Z |
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
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