Using Garbage Collection after import

[SteveB]

Hi All,

I am using the SqlBulkCopy for import data into ms sql 2005. I need to
import multipe files which could be from 1 to GB each. Is there need to use
a garbage collection for this purpose since the files are pretty big.

Here is class for the garbage collection:

http://msdn.microsoft.com/en-us/library/xe0c2357.aspx

Thanks,

Steve

[=?Utf-8?B?R2VvcmdlIFNodWk=?=]

RE: Using Garbage Collection after import

I guess you use DataTable as a param in BulkCopy.

Could you try DataTable.Clear () method to free the memory?

"SteveB" wrote:

Hi All,
>
I am using the SqlBulkCopy for import data into ms sql 2005. I need to
import multipe files which could be from 1 to GB each. Is there need to use
a garbage collection for this purpose since the files are pretty big.
>
Here is class for the garbage collection:

http://msdn.microsoft.com/en-us/library/xe0c2357.aspx

>
>
Thanks,
>
Steve
>
>
>