Click here to Skip to main content
15,892,927 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Friends,

I am using a MySql Server and I did create a table where I am saving a lot of documents.

The documents that I am saving are only PDF and each document dont exceded the 16MB.

My question is about the size of the disk in the server that hosting the database, because I

have registred 80 documents and the size of my backup file in the database is 116 MB.

Then, when I will have 1000.00 documents the size of my backup file will be increasing

considerably, this is the point that I don have clear, because I want keep a size of backup manageable, there is a way that I make a perfomance in the size of my mediumblob field in the
table?

what will be you recomentation about this case and your point of view.

Please give me your advices and your technical arguments about the use of Mediumblob data type
in my database.

Thanks in advance.

Leonardo Ayala R.
Posted
Comments
[no name] 19-Aug-13 11:41am    
Don't save the documents in your database. Just save the path to the documents in your database.
Ron Beyer 19-Aug-13 11:48am    
Agreed, databases are not file systems and should not be treated as such.
leocode7 19-Aug-13 13:25pm    
http://shaiekh.com/home/where-to-store-uploaded-files-filesystem-vs-database/
leocode7 19-Aug-13 13:23pm    
http://shaiekh.com/home/where-to-store-uploaded-files-filesystem-vs-database/
leocode7 19-Aug-13 12:34pm    
Thanks a lot my friends.

1 solution

Don't save the documents in your database. Just save the path to the documents in your database.


databases are not file systems and should not be treated as such.


http://shaiekh.com/home/where-to-store-uploaded-files-filesystem-vs-database/[^]

(Thanks to Leonardo Ayala)

How to store and fetch binary data into a file stream column[^]

Thanks to Mika Wendelius.
 
Share this answer
 
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900