hey all.. new to the list. Just my 5 cents... I think it's better to store images in the database, sure you loose a bit in performance, but it's easier to code.
The way i've done it before is always a separate render.php (or what ever) that compares the users rights to view that image, get's the blob from the database, sets right content-type for the page and then renders the binary data. That way... you can control frames/design (direct links to images can be avoided) und so weiter... //lars On Thu, 20 Mar 2003, B. van Ouwerkerk wrote: > I assume it is, have not tested it.. > > If you need to fetch the files from the database your app needs to wait > until it has recieved the data. If you only store name/path info it will > take less time to fetch the data, ship it off to the browser which can > start fetching the images without connecting to the database again. > > Sounds pretty logical.. and it gets worse if your site is hosted by an ISP > who is using a database server running on a seperate box.. > > > B. > > > At 21:35 20-03-2003 +0000, Lai Liu-yuan wrote: > >Well, this may be off topic. > > > >In my case, I store tens of thousands of images, gradually growing. All of > >them are quite small, most around 30*30 gray scale. Would it still be > >faster to store them on disk? > > > >On Thu, 20 Mar 2003 13:57:06 +0100 > >"B. van Ouwerkerk" <[EMAIL PROTECTED]> wrote: > > > > > IMHO it's better to store a link. > > > I have seen databases (not MySQL) getting corrupted because the file > > > inserted was to big. > > > > > > For the visitor it doesn't really matter whether you put it into the > > > database or not. A link is less difficult and you don't have to retrieve > > > pictures from the database so it might be quicker.. > > > > > > > > > > > > B. > > > > > > > > > At 18:34 20-03-2003 +0000, Lai Liu-yuan wrote: > > > >I am now having a database storing images of chinese characters for > > > >research purpose. I wrote a program to store and retrieve them. My images > > > >are of type ppm. This is how I designed my table: > > > > > > > >mysql> describe poor; > > > >+--------+----------------+------+-----+---------+-------+ > > > >| Field | Type | Null | Key | Default | Extra | > > > >+--------+----------------+------+-----+---------+-------+ > > > >| cc | char(2) binary | | | | | > > > >| width | int(1) | YES | | NULL | | > > > >| height | int(1) | YES | | NULL | | > > > >| data | blob | YES | | NULL | | > > > >+--------+----------------+------+-----+---------+-------+ > > > > > > > >Just have to be really careful in storing binary data. Hope this help. > > > > > > > >On Thu, 20 Mar 2003 10:34:19 +0100 > > > >[EMAIL PROTECTED] wrote: > > > > > > > > > Hi! > > > > > > > > > > I have a problem with my MySQL > > > > > > > > > > I need to have some a images related with an item > > > > > > > > > > for example > > > > > > > > > > ------------------------------------------ > > > > > ! author ! date of birth an death ! image! > > > > > ------------------------------------------ > > > > > > > > > > How can I define the field for the images? I have read that LONGBLOB > > > > > could be useful for large objct like images, but I can't understand how > > > > > to set it in my database... > > > > > > > > > > Thank you in advance > > > > > > > > > > stefano > > > > > -- > > > > > S t e f a n o C a r d o > > > > > Debian GNU-Linux user > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > > > > > > > > >--------------------------------------------------------------------- > >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 > > > --------------------------------------------------------------------- > 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 > -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 (2002 update) GCM/GCS/GMU/ d+ s++:++ a-- C++(++++) UBLAIS+(++++) P+ L+(-) E--- W+++ N+ o-- K w O- M- V- PS(+++) PE++ Y PGP- t 5+ X++ R- tv+ b+ DI+++ D- G e h++ r% y++ ------END GEEK CODE BLOCK------ --------------------------------------------------------------------- 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