Groups > comp.lang.java.databases > #105

Re: In need of advise abo

From	"David Harper" <david.harper@THRWHITE.remove-dii-this>
Subject	Re: In need of advise abo
Message-ID	<n_EWj.3471$DZ6.2765@text.news.virginmedia.com> (permalink)
Newsgroups	comp.lang.java.databases
References	<cJCWj.1024$ll1.990@trndny06>
Date	2011-04-27 15:21 +0000
Organization	TDS.net

Show all headers | View raw

  To: comp.lang.java.databases
Dave Miller wrote:
> mebe wrote:
>> Hello,
>>
>> 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.
> 
> AFAIK, the db manipulates blob handles and id not the data itself. If 
> that's correct, it's  doing very_minimally more work than would be done 
> by the file system if you wrote straight to disk.

MySQL's MyISAM engine stores the actual blob data in the .MYD files.  It 
doesn't do anything tricksy with blob locators like some other systems.

David Harper
Cambridge, England

---
 * 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

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

In need of advise about s "mebe" <mebe@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Dave Miller" <dave.miller@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "David Harper" <david.harper@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Dave Miller" <dave.miller@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Jeffrey H. Coffield" <jeffrey.h..coffield@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Jeffrey H. Coffield" <jeffrey.h..coffield@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "BoBi" <bobi@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "Thomas Kellerer" <thomas.kellerer@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: In need of advise abo "RedGrittyBrick" <redgrittybrick@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000

csiph-web