|
|
Posted by max.schulze@googlemail.com on 06/12/07 15:30
On Jun 12, 5:09 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> cbmeeks wrote:
> > I am writing my own family photo sharing site that I hope to take
> > public (like so many others). Anyway, currently, when the user
> > uploads a picture, I store the picture outside my htdocs folder and
> > record the image details in a MySQB db. When you browse the picture,
> > I read the record and build the image by sending an image/jpeg header.
>
> > Seems to work but I am a little disappointed with performance.
> > Granted I am running on a really old machine which might be the
> > reason. lol
>
> > Seriously though, if I take this public and get extremely lucky and
> > millions of photos are uploaded, would this be the best method?
>
> > I've read pros and cons of storing images in a database. I've read
> > about Flickr, SmugMug, Photobucket having HUNDREDS of millions to over
> > a BILLION images stored!
>
> > Obviously, load balancing plays into this but what other secrets do
> > you think they use?
>
> > One thing I worry about is my file system. I have something like:
>
> > pix
> > -----user1
> > -------------thumbs
> > -----user2
> > -------------thumbs
>
> > etc...
>
> > Any pointers would be appreciated.
> > Thanks
>
> > cbmeeks
>
> First of all, you should be asking this in a database newsgroup, not a
> PHP one. And preferably a newsgroup aimed at the database you're using.
>
> I store pictures in databases. It works quite well. Takes some tuning,
> but I find it provides good performance.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
You should read the Database DOCS. In case of MySQL, if you index your
table and use the right mysql database type, then you will get more
perfomance with storing images in the database.
Also if you run a very huge site, your database server's will run on
SCSI machine's which means that you have often faster Database
Harddrive's then your webserver.
Navigation:
[Reply to this message]
|