Subject | RE: [IBO] Optimize massive inserts with TClientDataSet + IBO |
---|---|
Author | Jason Wharton |
Post date | 2007-10-04T00:37:54Z |
You might try putting an INSERT statement into the InsertSQL property so
that it will use the same parameterized statement for each insert. Also,
you will want to make sure that you are not having AutoCommit on and not
have called StartTransaction. If that is the case each insert would start
and end a transaction.
Jason Wharton
that it will use the same parameterized statement for each insert. Also,
you will want to make sure that you are not having AutoCommit on and not
have called StartTransaction. If that is the case each insert would start
and end a transaction.
Jason Wharton