On Tue, Oct 21, 2003 at 11:31:49PM +1000, Tim Starling wrote:
Brion Vibber wrote:
It might be the simplest thing to just store
uploads directly as blobs
in the database. When a request comes to serve an uploaded file, we can
cache it in the local filesystem (or memory) if we like to speed access
and allow read-only access with the db server down. This allows
resynchronization by checking cache time validity, and lets images be
backed up along with the rest of the db.
Like you say, it's certainly convenient. It wouldn't be too hard to do a
small-scale speed test. I guess we try it and see what happens.
The images could also be saved to a filesystem served by the new db box
(what's its name anyway?). FS access, even remote, should always be faster
than a db access.
JeLuF