<div dir="ltr">Hi everyone,<br><br>I discussed this issue a little with melanie in Mantis #2057. Thanks melanie!<br>Even though #2057 was turned into resolved, not fixable,<br>I still have some questions and want to discuss it with you all.<br>
<br>Please allow me describe this issue again in brief.<br>I first noticed the problem when I was testing attachment using MySQL,<br>that "assets" table increased without limit if you attach/detach repeatedly.<br>
Reading source code, there is no real deleting, updating, but adding on the table.<br>So I report it in #2057 and tried to attach a patch.<br>And melanie explained the reason why assets cannot be updated or deleted.<br><br>
The point could be whether the records in assets table can be updated or deleted.<br>1. Is it good technically that asset table is increasing without any limit?<br>
2. In case of attachment, for example,<br> if an attached object is not shared with others, after modifying or when<br> detaching it, should we still create a new record in assets table, letting<br> the previous one become garbage and never be used?<br>
I think the process on attachment should be improved. But that could be based<br> on how assets work.<br>
<br>Cheers,<br>Thomas<br><br></div>