[CLUE-Tech] apache and samba

[Mike Staver]

> I believe ColdFusion could handle this without resorting to PHP or Perl, but it
> might be a little troublesome with LOBs and such (as those suckers always are).
>  The database size would be little or no greater than the size of those same
> files on disk and file retrieval is generally just as quick from inside the
> database as off of the file system.

Yeah, you're right - I can do almost anything with CF that you can do 
with PHP. My only concern was database size.  We have a M$ SQL server 
running which currently holds all of our data, and the current database 
size is around 200 meg after 4 years of use, which amazes me. There are 
thousands and thousands of rows in some of those tables, and we have 
around 125 tables last time I checked.  I back up the database 3x a day 
to tape (DDS3), so if the database grew at a fast rate, that may 
eventually slow things down, but I would guess it wouldn't be too bad.

> This idea I actually kinda like.  The shell script could be called from a
> ColdFusion  <CFEXECUTE > tag and copy the file to the other two servers.  I'd be
> a little worried about names and versions and such, but it's interesting for sure.

I see what you're saying here - I guess I could have each webserver that 
accepts an upload also send it out to the other 2 servers at the same 
time.  The only thing I think that would be hard is error handling, like 
if it uploads to 2 servers and fails on a third.

Still, I think the BLOB idea is the more secure idea, and probably more 
stable than using SMB to connect to the fileserver.

-- 

                                 -Mike Staver
                                  staver at fimble.com
                                  mstaver at globaltaxnetwork.com