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

[Sean Dague]

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

-- 
Sean Dague / Neas Bade
sdague at gmail.com
http://dague.net


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20090401/1b899cf4/attachment-0001.pgp>