Hallo Martijn Tonies,

Thomas Besand wrote:

>right now I'm writing a program that is used to administer adresses. I'm
>> using FB 1.5.2 as the DB. The programm itself is written in Delphi 5
>> with ZEOS Data Access Components.
>

>Because of frequent crashes while importing textfiles containing > 1
>> mio. records, I implemented a mechanism that allowed the user to resume
>> a crashed import.
>>
>
>That way I hoped to come around the memory problem with large files.
>> But nope: what happens is, that with the first call to tblWriteData.Post
>> I can watch the amount of used memory in taskman.exe going up like a
>> rocket, until it is around the amount that previously caused the program
>> to crash. Eventually it would write a few more records, but that's not
>> what I intended.
>
>
>
>
>

Martijn Tonies wrote:

>Try an INSERT INTO statement, prepare it, process each row in the
>text file.
>
>Do NOT use .Post
>

Thanks a lot for your suggestion. Took me some time to rearrange
proceedings- but now things look smart again.

Greets
TBesand