Hello,
I am working on a peice of code that takes a file and loads it into a SQL
Server DB.
When I load large files (over 70Mb) I get a system out of memory exception.
My machine has 2G RAM
I think the problem is that a file stream pointing to the file on the file
system is loaded into a memory stream one byte at a time. Does anybody have
any pointers on doing this type of thing and how to do this so that the file
is actually streamed from the file system right into the SQL Server DB?
Any advice or links to articles on how to do this best etc would be really
appreciated.
Thanks in advance for any help
--
Regards,
Phil Johnson (MCAD)