The blob issue (Update)

Though I managed to salvage the blob issue, it was a quick fix and not the best recommended way to handle file uploads. It is best practice to have the file system handle uploaded files and then just keep the file paths in the database for retrieval later.

Saving files as blobs in the database results in your database growing exponentially, backups start to take longer and longer. This also starts to affect retrieval as opening that table start to take longer and slows the system.

A long term fix will be achieved in two steps. First is converting the existing files in the database back to files and saving them in a folder with relevant paths retained the database, second is to save new files directly to the designated folder and similarly save their paths to the database.

 

Advertisements

One thought on “The blob issue (Update)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s