Please also add the below calls to BeginBusy and EndBusy as they will
eliminate the SQL Hourglass flickering.

Jason Wharton

> Var
> MyParam1, MyParam2: TIB_Column;
> Begin
> IB_DSQL1.SQL.Add('INSERT INTO MyTABLE(...)
> VALUES(:MyParamName1, :MyParamName2)');
> IB_DSQL1.Prepare;
> MyParam1:=IB_DSQL1.ParamByName('MyParamName1');
> MyParam2:=IB_DSQL1.ParamByName('MyParamName2');

try

IB_DSQL.BeginBusy( false );

> While not <All records inserted>
> Begin
> MyParam1.AsInteger:=<number>;
> MyParam2.AsString:=<string>;
> IB_DSQL1.Execute;
> End;

> IB_Transaction1.Commit;

finally

IB_DSQL.EndBusy;

end;

> End;
>
> This should speed up things considerably,
> Set
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of hamacker
> Sent: 28. november 2007 17:19
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Transfer a large database 2GB to FB using
> IB_Query. Memory growing up a lot.
>
> Hi again,
>
> I need to transfer database clients in MSSQL to FB2 database.
> I create a simple application that read one record from MSSQL and
> using IB_Query (insert...values) transfer to FB2. ex:
>
> IB_Query1.SQL.Add('INSERT INTO TABLE(...) VALUES(...)')
> IB_Query1.ExecSQL;
> IB_Query1.IB_Transaction.Commit;
>
> But something is wrong, when start the memory of server (localhost) is
> 240M, after 10 min then 340M, after 45 min 1GB of RAM and growing up.
>
> How can I fix this ?
>
> I migrate from IBX last month to IBO, and I use IB_* suite.
>
> I using delphi 6 + IBO4.
>
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]