Question about BLOB datatypes
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
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.