Storing Pics in blobs.. speed?

[Dustman]

Has anybody ever benchmarked retrieving jpgs from mysql? I have thousands of pictures that are served up on websites all over the place.. currently I'm just storing the links. I'm looking into storing them all in blog fields. I'm not worried about the actual programming, I know what it takes to do it.. I just want to know if serving up the data would be faster or not.

-Dustin
Rom 8:28

 

[lebisol]

Hello ingresman!
THank you for sharing...this was very informative for me, even though I jumped on the post a bit late.
A lot of time I find myself too involved into programing that I forget about admin side of this or vice versa....it is always good to hear different approaches and "triks" that people use.
So, thank you gang....as you said, many way to apporach same things...

> need more info?
:: don't click HERE ::

 

[Dustman]

Lots of good stuff posted here. As with almost everything with programming, there isn't a universal answer.

With my situation, we deal with car dealerships. We take 6 pics of every car they have and are starting to store them all in a db. Size will not be much of a problem because every 90 days or so, almost all the cars have been sold.. we run a process every day that will move the old pics to a different location. Using a DB to do this makes it much easier for us because of the universal ease of transfer. We can suck it from server to server, db to db.. whatever we need and don't have to worry about what file system or anything. After weighing our options, we'd rather have to worry about some day far in the future having to move to a bigger db or back to the filesystem.

I'll still keep posting my tests as we make them.. it will be several more weeks before I can get some serious results to post.

Thanks for all the replies.. keep them coming!

-Dustin
Rom 8:28