Geoff Worboys wrote:
[...]

>In this table I found that the Assign worked faster than the
>AsString assignments...

[...]

I re-try with DSQL and Assign method version by refer to your codes.
This result is faster than AsString method with D7 too.

Minoru wrote:

>Delphi7 Ent/IBO V4.8.7
>=== Test_IBO (Parameterized-insert)===
>App Init Time: 0ms
>Object Prepare Time: 31ms
>Records Transfered: 100000
>Records Transfer Time: 18284ms
>Transaction Commit Time: 780ms
>Connection Close Time: 0ms
>Application Run Time: 19095ms

=== Test_IBO (Parameterized-insert with DSQL and Assign method)===
App Init Time: 0ms
Object Prepare Time: 47ms
Records Transfered: 1000000
Records Transfer Time: 165673ms
Transaction Commit Time: 1186ms
Connection Close Time: 0ms
Application Run Time: 166906ms

Geoff Worboys wrote:

>With the later blob intensive table there was almost no
>measurable difference (most of the time for the 106 rows
>is spent in transferring blobs).

I try added the blob(subtype 0) col in "MyTable" as bellow.

"F" BLOB Sub_Type 0 Segment Size 8192

This blob col inserted into 162,235byte, all 10,000 rows.
DB size was 1.6GB (1,674,428,416byte).

=== Test_IBO (Parameterized-insert with DSQL and Assign method)===
App Init Time: 0ms
Object Prepare Time: 63ms
Records Transfered: 10000
Records Transfer Time: 138372ms
Transaction Commit Time: 3744ms
Connection Close Time: 47ms
Application Run Time: 142226ms

This performance is no problem for me :)
Sorry,i can't testing with the D2010.
( i don't have D2010, waiting for the next DelphiX in roadmap)
thanks for your informations.

--
Minoru