Our applications stores large CAD files in an SQL 2005 database field VARBIN(max). A few of these documents are in excess of 100MB in size. Our application throws an “OutOfMemory” exception when attemption to download or upload these large CAD files.
This is government data, so we put the drawings into a database field for security purposes.
The webserver is running 32bit Win2003 and IIS6, it has 2GB RAM.The sqlserver is running 32bit Win2003 and MS SQL 2005, it has 2GB RAM.