Hi,

> 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.

Use the non-buffered TIB_Cursor.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com