Re: suggestions for binary data in database
| From: | Jason Stechschulte | Date: | Mon, 30 Apr 2001 19:41:24 +0000 |
| Subject: | Re: suggestions for binary data in database | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-50906@lists.php.net to get a copy of this message | ||
On Fri, Apr 27, 2001 at 03:24:36PM +0200, Ray Hilton wrote:
> However, on the site, i am currently storing images in the database, purely
> because i can. But i wonder, how much will the server load be affected when
> pulling binary data out of the database? compared to the file system? i
> assume its going to be quite a lot higher. DO you reckon it would be better
> to scrap that and store the images on the file system?
Yes, I certainly reckon that. Using the database can make organizing
them easier, but I usually find it pretty easy to store images on the
file system and only put the directory structure, filename in the
database. It is much easier on the database too.
--
Jason Stechschulte
jpstech@unoh.edu
--
Unix is like a toll road on which you have to stop every 50 feet to
pay another nickel. But hey! You only feel 5 cents poorer each time.
-- Larry Wall in <1992Aug13.192357.15731@netlabs.com>