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

[Melanie]

Hi,

we have had this discussion here before. If you can access the list 
archives, you can look it up.

Even I had, at one time, made a change that would have made assets 
updatable, but it was rejected, Assets are immutable. Hard and fast 
rule.

Really, storage is cheap. MySQL still delivers really good retrieval 
times with 36 million records, so if I were you, I wouldn't worry 
about it.

Melanie

Tao YANG (GMAIL) wrote:
> 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
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev