List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:June 28 1999 5:20pm
Subject:Re: to much fragmentation
View as plain text  
>>>>> "SH" == Scott Hess <scott@stripped> writes:

SH> That (storing the blobs out to the filesystem) is the solution we're
SH> currently pondering.  The main downside is that the database is being used
SH> as the central "memory" for a system that involves a couple components, and
SH> we'd _really_ rather not teach all components about the off-database blob
SH> storage, if we can get away with it.

One common technique is to keep blobs out of all tables except one.
This table would consist of two fields: a unique ID and the blob
data.  Then, like you normally would keep the blob on the file system
and store a reference to it, you instead keep the blob data in that
table and store a reference to it.  

This way you keep all your data in the blob and the only fragmentation
you may have is in the blob table.  This really won't matter too much
since the time to transfer the data over the network will be much
larger than the time to seek the disk around those fragments.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
to much fragmentationDavid Johnson26 Jun
  • Re: to much fragmentationSasha Pachev27 Jun
  • Re: to much fragmentationScott Hess28 Jun
    • Re: to much fragmentationVivek Khera28 Jun
    • Re: to much fragmentationMichael Widenius29 Jun
      • Re: to much fragmentationEd Carp29 Jun
        • Re: to much fragmentationSasha Pachev29 Jun
        • Re: to much fragmentationMichael Widenius29 Jun
          • Authentication methodsRoger Smith29 Jun
            • Authentication methodsJani Tolonen1 Jul
        • Re: to much fragmentationScott Hess29 Jun
      • Re: to much fragmentationEd Carp29 Jun
        • Re: to much fragmentationMichael Widenius30 Jun
      • Re: to much fragmentationT├Ánu Samuel29 Jun
  • Re: to much fragmentationScott Hess28 Jun
Re: to much fragmentationFred Lindberg28 Jun