Re: Database and files
| From: | Richard Archer | Date: | Mon, 22 Apr 2002 10:40:37 +0000 |
| Subject: | Re: Database and files | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-93964@lists.php.net to get a copy of this message | ||
At 11:25 AM +0100 22/4/02, Danny Shepherd wrote:
>If you get multiple requests for files, expect the db to fall over very
>quickly - what's wrong with storing them on the filesystem and having a list
>of them in the db?
If your DB falls over, get a better one. You wouldn't do this with
Access, but MySQL or PostgreSQL will handle this with no problems.
And storing them in the file system requires the web server process to
have write access to the directory in which the files are stored. And
so will any other users on that server. Security nightmare.
>One thing - note that that the header names and the actual mimetype are in
>lower case. Got weird results with anything different.
Interesting tip. I'll try that out on Mac IE which never did download
properly, IIRC.
...R.