I did try your example and it did work wery good. 6000 rows/sec with
country table and 4000 rows/sec with a table that have four columns.

Thanks for that.

--- In ib-support@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> Maybe you're trying too much? I would expect something like
>
> IB_DSQL1->BeginBusy(true);
> try
> IB_DSQL1->sql = "INSERT INTO COUNTRY VALUES(:Param1, :Param2)";
> IB_DSQL1->Prepare;
> for (int a = 0; a <= 5000; a++)
> {
> IB_DSQL1->Params[0]->AsString = IntToStr(a);
> IB_DSQL1->Params[1]->AsString = IntToStr(a);
> IB_DSQL1->Execute;
> }
> IB_Transaction1->Commit;
> finally
> IB_DSQL1->EndBusy();
> end; (I am a Delphi programmer, so the C++ code is probably quite

wrong)

>
> to be faster than 1000 rows/sec.
>
> Additional things that could help your speed, is to call

DisableControls or

> set ForcedWrites off. Jason is a pretty clever programmer, so I

don't think

> there too much to gain by reinventing the wheel.
>
> Set