MySQL Forums
Forum List  »  Newbie

Question about BLOB datatypes
Posted by: Jassim Rahma
Date: July 23, 2019 06:13PM

Hi,

I'd like to ask about the BLOB, MEDIUMBLOB and LARGEBLOB datatypes please

I want to save student images in my application and I am thinking to store it in the database but I am afraid of the performance

so... can you please explain a bit about this?

for example..

does the BLOB save the image itself in the database or it just save a reference to it and in the backend it saves the physical file somewhere on the drive (something similar to Oracle BFILE)?

what if I have student images for 400-600 students every year? won;t this affect my performance because of the database size?

Also if I am going to save the students' certificates and legal documents which are in PDF as well as images.. won't this be too much for the database?


Kindly Advise...


Thanks,
Jassim

Options: ReplyQuote


Subject
Written By
Posted
Question about BLOB datatypes
July 23, 2019 06:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.