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
