Pictures in MySQL database ? - GoFuckYourself.com

qw12er · 09-18-2005, 04:43 PM

I heard it wasn't really reliable ?

What are your thoughts on the subject ?

calmlikeabomb · 09-18-2005, 04:48 PM

Just store the location of the image in your db.

qw12er · 09-18-2005, 04:56 PM

Nah I need to have quick access to the files since I'll have to process thousand of them.

blazin · 09-18-2005, 05:00 PM

Sounds like you've already made up your mind... but if your gonna do it then store them in a seperate table on their own.

qw12er · 09-18-2005, 05:03 PM

I'm considering storing them on a FTP too. Whould be cleaner in DB...

Why should I store them in a separate table ? (sounds like a good idea though)

pythonx · 09-18-2005, 05:08 PM

Quote:

Originally Posted by qw12er

Nah I need to have quick access to the files since I'll have to process thousand of them.

Your database will grow very quickly, but its very reliable if you store them correctly as a BLOB. I tested speed on requesting images in a mysql db vs images stored on server and there was not much difference in speed.

TMM_John · 09-18-2005, 05:10 PM

You want to store the DATA of an image in a MySQL database?

Why?!

Store it on disk and store the location of it in a table.

qw12er · 09-18-2005, 05:20 PM

Quote:

Originally Posted by PBucksJohn

You want to store the DATA of an image in a MySQL database?

Why?!

Store it on disk and store the location of it in a table.

Efficiency. I will have to process 100'000's of picture every day.

TMM_John · 09-18-2005, 05:24 PM

Quote:

Originally Posted by qw12er

Efficiency. I will have to process 100'000's of picture every day.

I'm just wondering how storing it in a DB rather than a reference to it in a DB makes it easier for you? (not trying to be sarcastic, I'm geniunely curious)

AmigoPorn · 09-18-2005, 06:28 PM

Quote:

Originally Posted by PBucksJohn

You want to store the DATA of an image in a MySQL database?

Why?!

There are benefits in doing that. Especially if you need a true DDB.

quantum-x · 09-18-2005, 06:34 PM

it's very possible, I've done it on a few of my sites.
Just stick it in the blob structure, and use php's great tmp_file procedure!

_Lush_ · 09-18-2005, 07:45 PM

Never ever use MySQL for storing pics any database expert will tell you this
it affects performance greatly especially if you need mysql for other things besides a pic server

directfiesta · 09-18-2005, 07:51 PM

On one site, I use X-cart as a shopping cart ( about 300 products ). The default option is to store the images in the DB...
Tried both and it was more reliable and a tandy faster with images in DB.

09-18-2005, 04:43 PM	#1
qw12er Confirmed User Join Date: Apr 2004 Location: Montreal Posts: 799	Pictures in MySQL database ? I heard it wasn't really reliable ? What are your thoughts on the subject ? __________________ I have nothing to advertise ... yet.

09-18-2005, 04:48 PM	#2
calmlikeabomb Confirmed User Join Date: May 2004 Location: SW Palm Bay, Florida Posts: 1,323	Just store the location of the image in your db. __________________ subarus.

09-18-2005, 04:56 PM	#3
qw12er Confirmed User Join Date: Apr 2004 Location: Montreal Posts: 799	Nah I need to have quick access to the files since I'll have to process thousand of them. __________________ I have nothing to advertise ... yet.

09-18-2005, 05:00 PM	#4
blazin Confirmed User Join Date: Aug 2002 Posts: 2,781	Sounds like you've already made up your mind... but if your gonna do it then store them in a seperate table on their own. __________________ I don't endorse a god damn thing......

09-18-2005, 05:03 PM	#5
qw12er Confirmed User Join Date: Apr 2004 Location: Montreal Posts: 799	I'm considering storing them on a FTP too. Whould be cleaner in DB... Why should I store them in a separate table ? (sounds like a good idea though) __________________ I have nothing to advertise ... yet.

09-18-2005, 05:10 PM	#7
TMM_John Confirmed User Industry Role: Join Date: May 2004 Posts: 6,660	You want to store the DATA of an image in a MySQL database? Why?! Store it on disk and store the location of it in a table. __________________ Skype: JohnA1078 Too Much Media - Makers of the Industry's Leading Payite Management Platform, NATS!

09-18-2005, 06:34 PM	#11
quantum-x Confirmed User Join Date: Feb 2002 Location: ICQ: 251425 Fr/Au/Ca Posts: 6,863	it's very possible, I've done it on a few of my sites. Just stick it in the blob structure, and use php's great tmp_file procedure! __________________ PrettyInCash.com - BoozedGFs.com - TeenGFs.com - JizzGFs.com- MilfUploads.com -

09-18-2005, 07:45 PM	#12
_Lush_ Confirmed User Industry Role: Join Date: Jul 2005 Location: GDL Jal. Posts: 536	Never ever use MySQL for storing pics any database expert will tell you this it affects performance greatly especially if you need mysql for other things besides a pic server

09-18-2005, 07:51 PM	#13
directfiesta Too lazy to set a custom title Industry Role: Join Date: Oct 2002 Location: Montreal, Quebec Posts: 29,676	On one site, I use X-cart as a shopping cart ( about 300 products ). The default option is to store the images in the DB... Tried both and it was more reliable and a tandy faster with images in DB. __________________ I know that Asspimple is stoopid ... As he says, it is a FACT ! But I can't figure out how he can breathe or type , at the same time ....