Store a link to it. I see no advantage at all to storing binary data in a database. It just creates a lot more work for you by putting the data in a table. You have to create an "interface" to get at the data...or select it out into a file to get back the image, etc.
---John Holmes... > -----Original Message----- > From: PHP List [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 4:45 PM > To: php > Subject: [PHP] To store or not to store . . . > > Hi, > I was wondering about the following: > Should I store a picture directly in a MySQL table? Or just store the link > to a file on the system somewhere? > > I would think that leaving the picture as an actual file and just storing > the link would be quicker. But what are the dis/advantages of storing > right > in the table? I like the idea of not cluttering up my file system. > Pictures > would only be about in the 20K range. > > Thanks, > Chris > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php