well guys hello i am bit confuse on my way...i up to a project for my university and designing a database system for a school...the problem is i am uploading images and and i set the image type as blob in mysql db but one of friend suggest me that setting image type as blob is not a good technique as retrieving images from db because at certain case when there are more images it makes db heavily, you should post image as a name in db and then retrieve it from through img tab and specify the destination where it is save.please help me guys what should i do
extemer -17 Junior Poster Banned
debasisdas 580 Posting Genius Featured Poster
You can store either way
1. Convert the file into a binary stream and store the same in DB as BLOB.
2. Store the physical path of the file as a string in the DB.
Both as its own pros and cons.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.