Mysql Blob Image versus file system
Posted by erwin | Filed under
Finally, I've realised a major advantage of using the file system to store photos versus storing photos in a blob.
To store a photo in a blob you have to Base 64 encode it. This makes the filesize of the image larger (in some cases significantly larger... up to 33%!)
SO - If your hosting provider accounts your mysql usage in your disk quota, you are smarter to use the file system. If they don't account mysql usage in your disk quota, use mysql to gain extra space in your account.
If you're your own host, pick whichever method you prefer using. I prefer storing photos in mysql, but apart from the disk space argument, I've not found any convincing arguments to use one over the other (I don't notice any reduction in speed using mysql)
Post new comment