Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!news-xxxfer.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "BoBi" Subject: Re: In need of advise abo Message-ID: <1cb6190b-db34-4eec-a6ff-0d1edfaf85c5@a1g2000hsb.googlegroups.com> X-Comment-To: comp.lang.java.databases Newsgroups: comp.lang.java.databases In-Reply-To: <482b7a4d$0$90270$14726298@news.sunsite.dk> References: <482b7a4d$0$90270$14726298@news.sunsite.dk> 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:121 To: comp.lang.java.databases On May 15, 1:48 am, Arne Vajh=F8j wrote: > mebe wrote: > > i am working on a project where users are able to submit any ammount > > of large binary files. > > Currently all data is stored in a MySql database, but i am uncertain > > if it would be better/more efficient/faster to store the binary files > > on the filesystem. This would certainly save MySql from a lot of work, > > but ensuring data integrity could become complicated. > > I am uncertain if it is a good idea to move the binary data out of the > > database, so i appreciate any information. > > Thanks in advance. > > If it is huge files I would suggest using the file system > (unless you have database software and a real powerhouse of a database > server to handle it - think Oracle or DB2 on p595 or similar). > > But for smaller files (let us say below 2 MB to pick an arbitrary > size) on decent hardware (not your old 486), then I would find using > the database attractive. > > Performance will be approx. the same, but it will be much > easier to manage both app wise and operational. > > Arne Hi All, Thanks a lot all of you. I was struggling with the same question. Since most of my blobs are well below 2 MB I'll use my mysql db. :c), BoBi http://www.dongo.org --- * 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