Sigh, that wasnt realy the point of the email, but ok, i knew it could
happen when i wrote it.
The images -are- stored in the database in the product i'm activly
marketing, its a content management system, which can be administered via a
web interface. All text / html / images are stored in the DB for several
reasons, the most important one being - Cache Replication. my CMS behaves a
lot like StoryServer, it gets the image or template or html from the DB once
(when it knows its updated), saves it to local disk, and uses that to serve
pages to the web browser.. This allows very high scalability by clustering
many web servers, which only need a relativly under-powered db, while
retaining very high speeds..
So basicly the DB is used as a replication of data tool .. data stored in a
relational envirioment.
That 'serving images from a database' is the worst thing you can do, does
-not- mean there are no valid uses for storing binary data in a database
sometimes... thnx for assuming the worst guys ;-)
ps, in reply to some other email, yes backing up the site content is a lot
easier this way ... all it takes to backup a complete site is one mysqldump
statement. And yes the images make that dump pretty big, but actualy the
HTML is @least 10x larger then the images in practise..
-- Chris
"Carsten H. Pedersen" wrote:
> > > I would also strongly suggest not storing your images in the
> > database but
> > > rather a link to the image.
> >
> > even that - why?
> > if you're using an ultrafast webserver like Tux in combination with
> > Apache/php-perl
> > the Tux webserver serves the images incredibly fast (see specweb tests)
> > what advantage is the storing of a link to images in a SQL database?
>
> Because:
>
> A) There's no *point* in keeping the image in the database.
> A DBMS is all about searching, comparing, relations, etc. You
> get *none* of these by storing the image data in the DB.
>
> B) Unless you're careful, you totally defeat both the
> web servers and the clients ability to make use of caching
> mechanisms. While you may not see a big difference on the
> server, it can make one h... of a difference to the user
> stuck behind a 33.6K modem.
>
> I can think of more reasons, but these are enough to convince
> me that it's a Bad Idea(tm).
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
