[sldev] SL Database purge

[Gary Wardell]

Hi,

That all depends on the operating system.  Some use a b-tree.

There is also the theory that an OS should be very fast at finding and opening files since that's part of it's job.

OTOH, storing a blob in a row can slow down a database if it has to retrieve a row with a blob in it even though the blob is not
being used.

Gary
  -----Original Message-----
  From: sldev-bounces at lists.secondlife.com [mailto:sldev-bounces at lists.secondlife.com]On Behalf Of Dahlia Trimble
  Sent: Wed, April 30, 2008 4:58 PM
  To: Jason Giglio; sldev
  Subject: Re: [sldev] SL Database purge


  From what I've seen of Opensim, there are several optional asset storage mechanisms available that can be chosen in a
configuration file. It's also open source so an interested party could define a new mechanism and plug it in if one wished.

  I don't have much faith in the "files in a folder" approach as from what I remember from my operating system class (quite a
while ago), filename searches are linear searches.



  On Wed, Apr 30, 2008 at 1:35 PM, Jason Giglio <gigstaggart at gmail.com> wrote:

    Argent Stonecutter wrote:
    > In a tree-walking collector, that doesn't happen, but on the other
    > hand loops can hang the collector indefinitely. The operations on the
    > SL database should prevent explicit loops from happening, but they're
    > also inferring references from the contents of some assets, such as
    > scripts, and database corruption can create the damndest structures.
    > So what do you do?


    The tortoise and hare algorithm works extremely well for loop detection.

    -Jason


    _______________________________________________
    Click here to unsubscribe or manage your list subscription:
    /index.html



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.secondlife.com/pipermail/sldev/attachments/20080430/2ff2c1c5/attachment.htm