2 Replies - 278 Views - Last Post: 25 May 2012 - 09:39 AM

#1 ycpc55  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 27-May 08

Image stored in database

Posted 25 May 2012 - 09:33 AM

Hi
i have a question i was wondering if its ok to store images in a database if it's only for a short period of time? i know its not a good idea to store them in there and keep them in there but do the rules apply for short period of time as well? thanks...
Is This A Good Question/Topic? 0
  • +

Replies To: Image stored in database

#2 Dormilich  Icon User is online

  • 痛覚残留
  • member icon

Reputation: 3481
  • View blog
  • Posts: 10,038
  • Joined: 08-June 10

Re: Image stored in database

Posted 25 May 2012 - 09:38 AM

I think yes (unless the time period is explicitly mentioned). and there are different opinions what a "short period of time" is.
Was This Post Helpful? 0
  • +
  • -

#3 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 8937
  • View blog
  • Posts: 33,463
  • Joined: 12-June 08

Re: Image stored in database

Posted 25 May 2012 - 09:39 AM

I am not sure what rules (outside of less than stellar design).. I mean they are not going to be leaking pixels and colors in the tables and making a mess, right?

the best advice would be to split it into two tables.. one table as an index to contain all the text information about the image you are storing.. and the other to store the actual image. This speeds up search time when you hit the text only table and not the one house the binary array.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1