Sample Header Ad - 728x90

Better way to store file receipts

4 votes
2 answers
2373 views
I have a financial system that needs to attach PDF receipts for each record saved on my system. These receipts will be scanned by a proper device attached to the computer and saved in PDF to be stored in my database. Today the system saves the PDF file as varbinary(max), but because of the number of rows in my table, the filesize of my DB is increasing too fast. The average file size is about 1 to 2 MB. What is the best way to store these kind of files without compromising my database performance?
Asked by Junior Thurler (43 rep)
Dec 14, 2015, 07:13 PM
Last activity: Jan 31, 2016, 06:27 AM