[Opensim-dev] About Processing on Assets Table (Discussion #2057)

[Tao YANG (GMAIL)]

Hi everyone,

I discussed this issue a little with melanie in Mantis #2057.  Thanks
melanie!
Even though #2057 was turned into resolved, not fixable,
I still have some questions and want to discuss it with you all.

Please allow me describe this issue again in brief.
I first noticed the problem when I was testing attachment using MySQL,
that "assets" table increased without limit if you attach/detach repeatedly.
Reading source code, there is no real deleting, updating, but adding on the
table.
So I report it in #2057 and tried to attach a patch.
And melanie explained the reason why assets cannot be updated or deleted.

The point could be whether the records in assets table can be updated or
deleted.
1. Is it good technically that asset table is increasing without any limit?
2. In case of attachment, for example,
   if an attached object is not shared with others, after modifying or when
   detaching it, should we still create a new record in assets table,
letting
   the previous one become garbage and never be used?
   I think the process on attachment should be improved.  But that could be
based
   on how assets work.

Cheers,
Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080828/b1ca6b11/attachment-0001.html>