Re: Storing GIF\'s in MySQL

[Paul DuBois]

At 1:59 PM -0400 8/18/99, Urb LeJeune wrote:
>>I need to store GIF's in MySQL.
>
>	Why? increadable waste of space and performance destroyer.
>Why not just store a link?

I understand that you can get a degradation of performance if you do
a lot of inserts and deletes, unless you run OPTIMIZE TABLE regularly
to reduce fragmentation, but why would this affect performance otherwise.
I'm not sure I believe that the file system is faster at locating an
image file by searching through the directory than MySQL would be to
find an image record given an ID number.  I would expect the opposite.

As for wasting space, every file in a file system has wasted space,
unless it exactly fills up the last block allocated to it.  Why would
MySQL be worse than the file system?

-- 
Paul DuBois, paul@stripped