Hi jim,

Doing quite a bit of conversion work, I can't say I've got the same experience.

Make sure that table buffering is set off. Also, make sure that the recovery model of your database (database properties - options tab) is set to "Bulk logged"

Maybe there are some triggers (RI ?) in effect that cause the slowdown?

Walter,





>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