Hi, Folks! We are happy and up and running again.
Question: We have text were were thinking we would store on a file system on the webserver and just keep the name of the file in the database. These files may be as large as a million characters. Would we be wise to use a clob field or to stay with what has been working for us, i.e., just storing the files as files to the database? I like the transactional nature of storing things in the database but I don't know what other problems we might be getting ourselves into by storing such data in the database. We use Postgresql under Linux with TomCat. We are concerned, for example, that we will not find it easy to backup the database or that other issues, not nec. cayenne related my mess us up. Thanks! Eric +1 (917) 589-6579 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
