Wondering if anyone can shed light on this.

OK, so I've got my basic COM classes doing what I want. Today I coded a quick class, deployed it and set it running.

This class opens a 1GB fixed-field file, reads one record, and INSERTS one record into a DBF. Then it loops through until it's digested the whole file. Then there are three more to do after that. Only about 10% of the data is used, which is why we're not doing a simple APPEND FROM...

My question is about RAM usage. I've got the task manager running, and watched the process's RAM usage climb up to 175MB (on my 256MB machine) or so before it levelled off. It hit 175MB after less than 200,000 records had been processed.

What I can't figure out is how it could chew up so much RAM on a record-by-record loop. I don't want to put it onto an MTS server knowing that it could drive the machine into a virtual memory thrash. Any ideas?

As always, TIA...