[Opensim-dev] Proposed additional db fields

[Sean Dague]

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.

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.

	-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/20081103/eea5a24e/attachment-0001.pgp>