Member Avatar for sivaslieko++

Should I store images as binary or should I store their paths into database? Do you think which one is more advantageous?
I am waiting for your suggestions..

Have a good programming :))

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by ptaylor965
Member Avatar for ptaylor965

I would store the location of the images in the database.

This is because images like *.jpg are compressed with nice small file sizes designed for the internet but when stored in a database they are not compressed.

To see the difference save an image in *.jpg then resave as *.bmp as *.bmp files are not compressed


I have done this before for an internal network application and decided that it would be better to have a small database and image storage area then to have a large database


Plus it requires a large amount of code to convert the image into binary and back compared to just getting the location.

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.