I have a process that will load a couple of million records in BO to do a duplicate record search. My process will import thousands (360K+) of records and then I need to make sure those records does not exist in the database, so instead of querying the data 360k+, I load a BO with all possible duplicate records to check against and this is the million records BO.



Now the problem is that even when I do a BO.Clear to remove those records the application keeps using a lot of memory (over 1gb) and that memory is not released until the whole application is closed, so when the import process starts again, it will blow up with a not enough memory to complete the process.



So what should I do in order to make sure that the memory used once the million record BO is filled is released when using BO.Clear?



Also I am open to suggestions to change my approach if I need to.



Thanks!

Edhy Rijo

Hi Trent,



Will the new SF release 1.7.0.6 have any effect in this issue with the MDI forms?



My trial version of ANTS expired and I cannot test your sample application with new SF assemblies.

Edhy Rijo

Most likely the two are unrelated since the code you are referring to is not SF specific but rather .NET specific.  But I will run a test to see.