Re: [PHP-DB] Images on MySQL
I keep hearing this from people (not to store images in mysql), but I would like to hear a bit more about why. Mysql has blob fields, so it seems perfectly reasonable to use them, doesn't it? I'm storing some images in a database and what's attractive to me about it is that I can put the images anywhere I like. I guess I could mount an image directory over NFS, but it seems easier and more consistent to use sql. Any thoughts on this? -Steve On Friday, March 29, 2002, at 05:43 AM, Jason Wong wrote: > On Thursday 28 March 2002 19:35, Clever wrote: >> Hi, >> I'm designing a site and I have to store a lot of images. >> Which is the best for speed? >> 1) Store all images on a MySQL table? >> 2) Save them on disk like normal files and only have pointers to them >> on >> the database? > > 2) > > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > /* > The only difference in the game of love over the last few thousand years > is that they've changed trumps from clubs to diamonds. > -- The Indianapolis Star > */ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Images on MySQL
On Thursday 28 March 2002 19:35, Clever wrote: > Hi, > I'm designing a site and I have to store a lot of images. > Which is the best for speed? > 1) Store all images on a MySQL table? > 2) Save them on disk like normal files and only have pointers to them on > the database? 2) -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* The only difference in the game of love over the last few thousand years is that they've changed trumps from clubs to diamonds. -- The Indianapolis Star */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Images on MySQL
In my experience storing images on disk is simpler, easier and not messy. I wouldn't think of storing binaries in a MySQL table...It just doesn't seem right, but then again I have never tested this, only relied on my peers telling me "It's not right" ;) -Lasse - Original Message - From: "Clever" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 12:35 PM Subject: [PHP-DB] Images on MySQL > Hi, > I'm designing a site and I have to store a lot of images. > Which is the best for speed? > 1) Store all images on a MySQL table? > 2) Save them on disk like normal files and only have pointers to them on the > database? > Thanks a lot > Clever Anjos > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Images on MySQL
Hi, I'm designing a site and I have to store a lot of images. Which is the best for speed? 1) Store all images on a MySQL table? 2) Save them on disk like normal files and only have pointers to them on the database? Thanks a lot Clever Anjos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php