[Opensim-dev] Proposed additional db fields

[Justin Clark-Casey]

Sean Dague wrote:
> Justin Clark-Casey wrote:
>> 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.
> 
> I think we'll need to implement to see, I don't think it will be
> substantial overhead.

These are database writes.  But I guess it isn't too bad since I assume that we'll only write it once when the asset is 
first pulled into cache (assuming one doesn't have very very long running OpenSim instances - which is a bit unlikely 
right now :).  However, at sim startup there could be a substantial number of such accesses (the scalability choke point 
being a large grid asset server).

But if you think that it's probably going to be okay then I'm happy to trust your judgement :)

> 
> My thoughts on acceptably old asset times for reap consideration were ">
> 6 months or > 1 year since last access".  My suggestion is we just cap
> cache times on regions to < 1 week, then we wouldn't be working on the
> same time scale.

Yeah, sounds reasonable.

> 
> 	-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