I would store the pdf's in separate location (on or off the server) under a unique UV assigned filename.
Then in the U2 database, store the original name, unique name, pathname and any other information. I'd use off server storage in case your disk space runs out, you won't chance crashing your U2 server. You can always connect your server to that location either via SMB / NFS / mapped drive so it can still appear to U2 as a local file if you need to get the actual pdf data. > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman > Sent: Friday, July 22, 2011 11:10 AM > To: U2 Users List > Subject: [U2] Document Management > > Does it make any sense to use a U2 database to save scanned pdf's? > That is... > > Does it make any sense to save small blobs in a U2 data base? > > Would a Type 1 file be best? > > Are there any advantages to using MS-SQL, MySQL, or some other database > technology? > > --Bill > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users