How to store files of size 50 to 100MB(max) on SQL server to be able to retrieve them faster? -


i store files in varchar(max) data type in table in sql server. retrieve them chunks using wbxml parsing. however, time consuming large files. example, file of size 60mb takes long, 7-8 minutes extracting. there efficient way either retrieve faster having current data type or should switch using other data type storing , retrieving file?


Comments