J
James Palmer
Guest
In our database we have a table that stores files as BLOBS. Due to the sorts of files people are adding it's bloating our database very quickly. I'm in the process of implementing compression on the files which is gaining us around 30GB already, but it's come to my attention that because of the way the code works we quite often end up with duplicate files in different BLOB records. We currently store the File Name in the DB record, and I can easily extrapolate the size of the BLOB using LENGTH(). I can test this for equality, but is there an alternative method I can use to establish if files are identical? Progress 11.2.1 on Windows
Continue reading...
Continue reading...