How about this...
I keep the same system I have in place that uses files but in addition I
also write the contents of each file to a Binary field where it is then
backed up using a Snapshot replication in SQL server. Then if I needed to
replace a file or even revert I could just pull the file from the DB. Would
this be a somewhat reliable method of backing up? What files won't work like
this?
Rick
_____
From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 10:41 AM
To: CF-Talk
I think you should throughly look into the pros/cons for storing simple
(binary) documents (word/images/pdf etc) in the database.
I think, in most cases, there will not be so strong advantages, and it
might be that this things might be better to serve from the file-system.
/H.
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 230460
UNEP GRID-Arendal Fax: +46 8 230441
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
<http://www.grida.no>
-------------------------------------------------------------
| -----Original Message-----
| From: cfhelp [mailto:[EMAIL PROTECTED]
| Sent: Tuesday, November 25, 2003 17:37
| To: CF-Talk
| Subject: RE: Documnet Library
|
|
| I am a bit concerned about the memory but I am looking for a
| way to make
| backing up easier and I can always buy more RAM.
|
|
|
| So to do this do I just write the content of the file to a
| Binary field and
| store the File Type and then use CFFILE to create a temp file
| on the server
| when it is requested?
|
|
|
| I am running
|
|
|
| Windows 2000 (will be 2003)
|
| SQL Server 2000
|
| CF5.0
|
| On a DELL 1gig DUAL Pentium with 1 gig of RAM.
|
|
|
|
|
| Thanks Ben
|
|
|
| Rick
|
|
|
| _____
|
| From: Ben Doom [mailto:[EMAIL PROTECTED]
| Sent: Tuesday, November 25, 2003 8:51 AM
| To: CF-Talk
|
|
|
| It will be something along the lines of "binary" but may
| depend a bit on
| your RDBS.
|
| Just remember, you're going to have to pull it from the DB
| and store it
| in RAM before you serve it this way. That can be taxing if the files
| are big.
|
| --Ben Doom
|
| cfhelp wrote:
|
| > I have been building a small document management system
| where Admins can
| > upload a share files with clients without using FTP (A few
| other things).
| >
| >
| > Right now the files are uploaded and stored in the users
| directory. I had
| > seen something a while back about actually storing the file
| in SQL server
| > and using CFCONTENT to produce the file for download.
| Anyone have tutorial
| > on this or some example code? What datatype does the
| database field need
| to
| > be?
| >
| > Rick Eidson
| >
|
| _____
|
|
|
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
