[Opensim-dev] Updating attachment assets

[Bo]

Hello,
i put my idea about live and backup assets tables which i mentioned here 
before into a Mantis.
http://opensimulator.org/mantis/view.php?id=5730

I think that we don't really need to purge assets. Only what we need is have 
unused assets, inventory folders and inventory items in separate backup tables 
so most of the operations is done within small tables and even grids with rich 
history can have very fast assets servers.

Bo

On Wednesday 05 of October 2011 01:06:55 Dave Coyle wrote:
> On Oct 3, 2011, at 8:01 PM, Justin Clark-Casey wrote:
> > Needless to say, distributed garbage collection is extremely hard.
> 
> A year ago I broke out the 20 million assets OSGrid had by file size[1],
> and 50% of them were <= 4KB uncompressed.  With deduplication and
> compression those 20 million assets would've taken up about 125GB of space
> on disk.  That was 3 years of stuff from tens of thousands of users.  It
> was easier and cheaper just to throw hardware at the problem and not worry
> about it than to come up with a mechanism to cull unused assets.
> 
> Granted, that was before mesh started picking up steam, and another grid's
> experience won't necessarily mirror that of OSGrid's.  But it's a data
> point.
> 
> [1] -- http://coyled.com/2010/09/23/osgrid-asset-sizes/ (those are
> uncompressed file sizes)
> 
> -coyled
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev