|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
10-19-2008
| #1 (permalink) |
| | Using Garbage Collection after import 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 |
My System Specs |
|
10-20-2008
| #2 (permalink) |
| | 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: Quote: > 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 > > > |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| garbage bin | Vista General | |||
| DEP Garbage | Vista security | |||
| Garbage Collection and PowerShell | PowerShell | |||
