Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: In need of advise abo

Show all headers | View raw

  To: comp.lang.java.databases
Roedy Green wrote on 16.05.2008 18:00:
> On Wed, 14 May 2008 05:53:35 -0700 (PDT), mebe
> <internetsux@hotmail.com> 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.

I vote for storing them in the database as well. Roedy has some very good points 
there (although MySQL isn't the best DBMS when it comes to handle concurrency, 
but that is a different story).

 From my experience there is another advantage when storing the files in the 
database: if the number of files gets above a certain number you need to 
distribute them across directories. Most filesystems aren't very good in 
handling thousands (if not millions) of files in a single directory.

Thomas

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