[Opensim-dev] Proposal to change user ID types in prims table to support external user profiles.

Melanie melanie at t-data.com
Wed Apr 1 20:03:51 UTC 2009


+1 for the creator, but local creators should still use the local 
profile data, because it's bound to be more available than an 
external resource.

I'm not interested in having it for owners, but others might be.

Melanie

Sean Dague wrote:
> Frisby, Adam wrote:
>> CHAR->VARCHAR shouldn't change too many performance properties. 
>> 
>> It may mean you lose fixed row size, but I doubt we didn't have any non-variable fields in the table anyway.
>> 
>> I suggest VARCHAR(255) for URI-storing fields.
>> 
>> +1 on changing to internet-unique addresses. (uuid at userhost?)
> 
> CHAR is much faster than VARCHAR, which we found on the UUIDs for the
> Objects (life got much better when those became CHAR for things like
> Asset IDs).
> 
> That being said, for user ids, that shouldn't be an issue.  +1 to uris
> for user references.
> 
> 	-Sean
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev



More information about the Opensim-dev mailing list