Hello All,
I have been reading hundreds of posts and sites for information regarding BLOBs in MySQL. So far I have not found an answer to my question, so I pose it to you fine people. :)
A little background first. I have a web server that uses PHP to retrieve documents in PDF format for viewing and printing. When I first developed the application I was storing the files on the file system. However about 7 months into the project, my file system was starting to get all but unmanageable. At 175,000 documents, I decided I needed a new mechanism for storing the files. So I began to use BLOBS.
I have started the project again, with BLOBs not yet importing the documents from the old project. Currently I have 10,780 files in the database, and all is working excellently. I have 3 tables, one for the BLOBs with unique keys, 2 table with the information regarding the BLOB, and a 3 table with the actual relevant information to the document.
So as I said, I am rather pleased with the performance and the ease at which I was able to get this up and running. However.... The problem is I do have limits, and one of those being disk space. Those 10,000 files are taking up 21 GB of space in the database. However the actual space required by the files is around 5GB on the file system. The average file size is about 1.9MB, so it would seem that each row inserted into the database is conforming to that 1.9MB average, giving me this 21GB table.
I would like to know if there is something that I can change to get these numbers in line with each other, or if this is just the way of things. Current projections for the total documents needed to complete the rotation of these files is 720,000 documents. Which if the 1.9MB average keeps, that puts me in the neighborhood of 1.4TB of storage.
Any thoughts?
Thanx, Justin
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
