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

[Frisby, Adam]

That's because you have an index on the ID. In the case where you don't have an index and won't be searching by those parameters, there's practically no difference.

Adam

> -----Original Message-----
> From: opensim-dev-bounces at lists.berlios.de [mailto:opensim-dev-
> bounces at lists.berlios.de] On Behalf Of Sean Dague
> Sent: Wednesday, 1 April 2009 12:56 PM
> To: opensim-dev at lists.berlios.de
> Subject: Re: [Opensim-dev] Proposal to change user ID types in prims
> table to support external user profiles.
> 
> 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
>