[Opensim-dev] Proposal to eliminate the name, description and invType fields from the assets db table

[Frisby, Adam]

It does impose an additional database lookup when fetching assets, but
it could lead to more efficient caching too. The latter I am
particularly interested in.

 

Regards,

 

Adam

 

From: opensim-dev-bounces at lists.berlios.de
[mailto:opensim-dev-bounces at lists.berlios.de] On Behalf Of Teravus
Ovares
Sent: Monday, 23 June 2008 1:21 PM
To: opensim-dev at lists.berlios.de
Subject: Re: [Opensim-dev] Proposal to eliminate the name,description
and invType fields from the assets db table

 

The only way for this to be extensable, and backwards compatible enough
really is to have the following structure.

 

InventoryItem ---->AssetUUID-----> DataHash

 

InventoryItem would be mapped to AssetUUID.  AssetUUID would have a many
to one relationship with DataHash..   this would allow for multiple
UUIDs generated the random way to be associated with a single data
object in the database.  

 

Best Regards


Teravus

 

On 6/23/08, Sean Dague <sean at dague.net> wrote: 

On Mon, Jun 23, 2008 at 03:59:39PM -0400, Teravus Ovares wrote:
> I'm not convinced the SHA1 UUID will be extensible enough to allow for
> future plans.   The idea is to not assume anything with a UUID.
Adding
> assumptions increases scalability at the cost of extensibility.

If we make UUID generation a static function that takes a reference to
the content we should be able to implement all 5 RFC UUID types today
(http://www.faqs.org/rfcs/rfc4122.html)

Presumably we'd just do implementations for version 4 (random) and
version 5 (sha1).  UUID type will be detectable as there are reserved
bits (though we'll probably need a path for "damn lindens don't follow
UUID specs, so here are some hardcoded UUIDs that are in the system that
don't follow specs").

   -Sean

--
__________________________________________________________________

Sean Dague                                       Mid-Hudson Valley
sean at dague dot net                            Linux Users Group
http://dague.net                                 http://mhvlug.org

There is no silver bullet.  Plus, werewolves make better neighbors
than zombies, and they tend to keep the vampire population down.
__________________________________________________________________

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIYAN1SamXem9TdyYRAtTbAJ9Yzuf1Luhy2DltPmZnF2/CsyNmVACfef6D
7lThzPS4+spuusW4kBrlYNk=
=dyDj
-----END PGP SIGNATURE-----

_______________________________________________
Opensim-dev mailing list
Opensim-dev at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080623/7046d485/attachment-0001.html>