Re: MySQL vs. Postgresql
| From: | Luke Welling | Date: | Thu, 12 Oct 2000 16:23:16 +0000 |
| Subject: | Re: MySQL vs. Postgresql | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-19825@lists.php.net to get a copy of this message | ||
"Dan Harrington" wrote:
> Would MySQL be a reasonable database to use for an image database where
> the images themselves were actually stored in the database?
>
> I am talking about ....jpegs, gifs stored in binary format in the SQL
> database, possibly 10 or 20,000 images.
Not really.
But there are a number of great 'databases' that are designed and optimised
for quickly and efficiently retrieving large binary objects from disk
storage given a unique key.
They are called file systems.
Unless you have a really good reason to, you should not be storing images in
an RDBMS.
Luke Welling
-------------------------------------------
luke@tangledweb.com.au
<gratuitous plug>PHP and MySQL Web Development by Luke Welling and Laura
Thomson
Available in December 2000 -
http://www.amazon.com/exec/obidos/ASIN/0672317842/
</gratuitous plug>
-------------------------------------------