RE: [PHP] To store or not to store . . .
| From: | Maxim Maletsky \(PHPBeginner.com\) | Date: | Thu, 25 Apr 2002 01:16:22 +0000 |
| Subject: | RE: [PHP] To store or not to store . . . | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-94491@lists.php.net to get a copy of this message | ||
> Personally I think databases these days (MySQL in my experience at
> least) are more than reliable enough and fast enough to serve up
> binary data in quite large quantities. If you run into performance
> issues, implement a caching solution run from a crontab.
I had a very, very bad experience with mySQL when a very simple table
(inserts at 99%) that got over 350.000 rows (100MB). So I wouldn't say
"MySQL in my experience at least". As I migrated that barely-lost table
to postgreSQL (almost identical designs) it still goes on and currently
has over 1.000.000 rows (400MB)
Just my .002 EuroCents.
The rest on why to keep the images in Db is a very good answer.
Actually, it is so good that I might even write an article on this
issue.
Sincerely,
Maxim Maletsky
Founder, Chief Developer
www.PHPBeginner.com // where PHP Begins