[Opensim-dev] Proposed additional db fields

[Alan M Webb]

Maybe the last accessed requirement could be more efficiently satisfied by 
a simple tagging mechanism? If an asset gets marked during the 6 month 
interval then it has been used at least once, and should be retained. If 
not then it might be lifted to a second level of asset storage. If the 
marking was done asynchronously with respect to normal asset operations, 
perhaps by a low-priorty region module that examined the current cache, 
then there would not need to be any real performance impact. I would 
definitely suggest that the last accessed info NOT be stored with the 
assets as metadata, it seems more sensible to store it in a separate 
table.

How much is this worth if we move toward an environment built around an 
effective asset server model? The same might be said about e-mail and 
agent servers, but I suspect the cost of adding the field is pretty 
trivial. Where was the week-end discussion? I didn't see it in this 
mailing list.

Best regards
Alan
-------------------
T.J. Watson Research Center, Hawthorne, NY
1-914-784-7286
alan_webb at us.ibm.com



Sean Dague <sdague at gmail.com> 
Sent by: opensim-dev-bounces at lists.berlios.de
11/03/2008 03:12 PM
Please respond to
opensim-dev at lists.berlios.de


To
opensim-dev at lists.berlios.de
cc

Subject
[Opensim-dev] Proposed additional db fields






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

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

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


_______________________________________________
Opensim-dev mailing list
Opensim-dev at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081103/be99c1f3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/octet-stream
Size: 260 bytes
Desc: not available
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081103/be99c1f3/attachment-0001.obj>