Re: Storing GIF\'s in MySQL

[Vivek Khera]

>>>>> "UL" == Urb LeJeune <urb@stripped> writes:

UL> You're correct, it has to be stored somewhere, but store it
UL> somewhere when its mere size doesn't degrade the performance of
UL> your DB. Let's assume that every row in your table averages a 60K
UL> gif. That's 60k the gets moved around almost every time you do a
UL> query, dump a table, etc. In addition,

Then you're doing it wrong.  Good database designers would put BLOB
type data into a table of their own with a unique ID for each.  Then
the places where you need these blobs you just store that ID.

Yeah, it is very much like storing the image on the file system and
recording a file name, BUT, you get to keep the client/server
abstraction and you get to make the DBA responsible for data safety.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       [phone]
PGP & MIME spoken here            http://www.kciLink.com/home/khera/