I handle files with a db pointer.
Works really good for me. I house all of the files
on a "static" server and put pointers in the DB.
Then I just update the DB with new pointers or remove
pointers as needed.
When looking up a file I request the DB file pointer
then use that info to grab it from the static server.
Works like a charm.
-bop
On Jul 3, 2007, at 9:34 AM, Clinton Gormley wrote:
On Tue, 2007-07-03 at 10:26 -0400, Perrin Harkins wrote:
On 7/3/07, Clinton Gormley <[EMAIL PROTECTED]> wrote:
1) In the DB, store the name of the server to which your file has
been
uploaded
I try to avoid files in the DB. It always ends in tears.
Sorry - I meant, store this in the DB:
- ID: 1234
- type: image/jpeg
- path: 12/34/1234.jpg
- server: images1.domain.com
So that your program would construct a URL pointing to the correct
server, or a translation layer would forward the request to the
correct
server
2) Store your upload in a shared partition (eg on a SAN, NFS,
iSCSI/OCFS2)
That's ok if you need them on every server. Many applications just
upload a file and process it on one server, so they don't need this.
Sure - I was thinking primarily of image hosting.
thanks
Clint
- Perrin