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...
Image stored in database
Page 1 of 12 Replies - 194 Views - Last Post: 25 May 2012 - 09:39 AM
Replies To: Image stored in database
#2
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.
#3
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.
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.
Page 1 of 1
|
|

New Topic/Question
Reply



MultiQuote







|