[Opensim-dev] Proposed additional db fields

[Justin Clark-Casey]

Sean Dague wrote:
> I've got a couple of proposed db fields that I think we should add in,
> but I want feedback before just putting it in.
> 
> users:
>  * email - this is added by a lot of the web based management stacks,
> and would be really handy to be in the base user definition.  I suspect
> this is non controversial.
> 
> assets:
>  * create_time - the unix timestamp when the asset is created
>  * access_time - the unix timestamp for last asset access

Something similar was proposed before for access time.  Do you think the performance penalty of updating asset access 
timestamp very often will be significant?

How will this play out when we eventually start caching some asset information on region servers.  An asset could go 
some time without accesses at the grid server when really it is being heavily used in the regions.

> 
> The rationale for these asset additional fields was some brainstorming
> this weekend on how we'd ever support asset reaping.  Why not perfect,
> this may help in determining what are active assets, and what are
> ancient assets that may be suitable for reaping.  Without these bits of
> information, we've got a hard time here.
> 
> Comments welcomed,
> 
> 	-Sean
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev


-- 
justincc
Justin Clark-Casey
http://justincc.wordpress.com