Thanks for the feedback. Just to clear up a couple questions regarding
my particular needs...
1. server has *plenty* of capacity
2. traffic is *very* low; max load would be 20 visitors looking at 4
images apiece over a 4-hour period
3. images will only be retrieved once or twice by one or two
Slightly OT, but I'm hoping for a few opinions about handling JPG/MOV
files with PHP/MySQL.
I've read that, given the choice, you should never store images in a
database because it makes the database dog slow. But I've got some
parameters and issues that might make a difference:
1. The only
Hello Derrick,
Wednesday, December 10, 2003, 3:56:32 PM, you wrote:
DF 1. The only way I can store the files in a directory on the server is
DF to make that directory wide open as in chmod 777. I don't have quite
DF enough control of the server to make that a better situation.
Why is this? More
Derrick Fogle wrote:
I've read that, given the choice, you should never store images in a
database because it makes the database dog slow. But I've got some
parameters and issues that might make a difference:
We (at hyperreal.info) are storing all the
images attached to articles in
I tend to disagree. Images in the database, providing they actually
associate with other bits of info, are great. I usually keep images in
a separate table than the data, but it's really easy to keep track of
everything. No file permissions, backup is as easy as standard SQL
backups, etc. I my
Galen wrote:
I tend to disagree. Images in the database, providing they actually
associate with other bits of info, are great. I usually keep images in a
separate table than the data, but it's really easy to keep track of
everything. No file permissions, backup is as easy as standard SQL
On Wednesday 10 December 2003 02:43 pm, Galen wrote:
If you store images that are played with a lot on
the disk, it'll likely be slower than MySQL due to MySQL having better
caching.
I disagree.
Depending on your setup, when a file based image is downloaded to
a user's computer, its cached
:35 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Images in MySQL vs directory/file?
On Wednesday 10 December 2003 02:43 pm, Galen wrote:
If you store images that are played with a lot on
the disk, it'll likely be slower than MySQL due to MySQL having better
caching.
I disagree.
Depending on your
On Dec 10, 2003, at 12:47 PM, [EMAIL PROTECTED] wrote:
Well, it seems to me that the confusion comes from the fact that we are
comparing apples and oranges.
I agree. Images in a database mean totally different things to
different usage profiles.
But I would also like to question the extra
Gerard Samuel wrote:
On Wednesday 10 December 2003 02:43 pm, Galen wrote:
If you store images that are played with a lot on
the disk, it'll likely be slower than MySQL due to MySQL having better
caching.
I disagree.
Depending on your setup, when a file based image is downloaded to
a user's
10 matches
Mail list logo