Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Roedy Green" Subject: Re: In need of advise abo Message-ID: X-Comment-To: comp.lang.java.databases Newsgroups: comp.lang.java.databases In-Reply-To: <5b7f9c08-d023-4ada-ab0d-ecab76965b65@b64g2000hsa.googlegroups.com> References: <5b7f9c08-d023-4ada-ab0d-ecab76965b65@b64g2000hsa.googlegroups.com> Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 39 Date: Wed, 27 Apr 2011 15:21:52 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303917712 96.60.20.240 (Wed, 27 Apr 2011 10:21:52 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:21:52 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:122 To: comp.lang.java.databases On Wed, 14 May 2008 05:53:35 -0700 (PDT), mebe wrote, quoted or indirectly quoted someone who said : > This would certainly save MySql from a lot of work, What in addition is the database doing for you? 1. arranging transaction rollback -- get rid of a blob not completely stored. 2. giving you ability to search by multiple tags associated with the blob. 3. making sure backup includes everything current. 4. if the input data exist in the filesystem, rather than coming in the wire, you will have an extra disk copy. 5. deal with concurrency problems. My gut feeling is let the database handle it , and only if you discover performance problems, experiment with using manual files. If you don't actually serve the files, then having them separate would make more sense. You are then just maintaining an index. -- Roedy Green Canadian Mind Products The Java Glossary http://mindprod.com --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24