I write conversion utilities for our company and deal with many tables that have enormous numbers of rows in them. Normally I'm converting from DB2 or MS-SQL databases to our database which is a MS-SQL 2K database. My development has been in VFP-9 for all this work. In a very large conversion I'm working on now it seems that my program starts off very fast in inserting rows into the MS-SQL tables but slows down dramatically as the program runs. For some of these tables it will run for many hours. One of my co-workers suggested that I may be experiencing what he referred to as a 'memory leak' in VFP and that I should be doing a FLUSH FORCE and a SYS(1104) after inserting 1000 rows into a table. I tried it but I'm not convinced that it's doing the job.
What is this 'memory leak' and could it be causing this problem? Is this a known problem that MS hasn't addressed in VFP-9?
Thanks!
Jim White
Time is a wonderful teacher. Unfortunately it kills all of its students.