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
Last activity: Jan 31, 2016, 06:27 AM