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
