Re: Re: Upload File (binary files?)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Am 2006-05-11 13:40:34, schrieb tedd:

> Plus, moving images from one system to another 
> was much easier because you just moved the dB and 
> you don't have to worry about the file system and 
> breaking links.

This can be done from a script to...

> In addition, if you are using multiple hosts, who 
> require the same images, then using mySQL is far 
> superior than trying to keep all the images in 
> different file systems synchronized.

This can be donw from filesystem too

    http://pics.your-domain.tld/path/to/pic.png

> Furthermore, according to Paul DuBois (author of 
> MySQL Cookbook, great book btw) who says "If you 
> store images on the file system, directory 
> look-up my become slow" in his comparing file 
> system to mySQL for image storage.

???

It depends, how many pics you have. But if you install a dedicated
Server for the pics with, e.g. 1 GByte of memory and apache 1.3.
It is fast as the heaven...  My Linux-Box hold all pics in memory.

> Granted, if you use mySQL for storing images, 
> then you bloat the tables and approach your 
> system limits faster than using a file system. 
> But for a limited amount of images, there isn't 
> any real problems.

Hmmm, My PostgreSQL is around 370 Gbyte now and if
I import all Pics, it would be around 1,8 TByte...

Good night...

> And for goodness sake NO, Google is NOT always 
> right -- it's only a collection of everyone's 
> view. When did Google replace valid research? I 
> can see tomorrow's mother's saying to their 
> children "If Google jumped off a bridge, would 
> you do it?"

Yes, because I like Bungee-Jumping...
(Paraglideing too)

;-)

Greetings
    Michelle Konzack


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux