[Opensim-dev] Opensim database management - garbage collection

[J Ross Nicoll]

Any chance of a number of times accessed field for assets, in addition  
to the access_time field?

While I'm looking at the assets table, is there any specific reason  
why creation/access times are stored as integers rather than using  
actual date & time types?

On 15 Jan 2009, at 00:24, Mike Mazur wrote:

> Hi,
>
> On Wed, 14 Jan 2009 22:22:09 +0000
> Ai Austin <ai.ai.austin at googlemail.com> wrote:
>
>> I wonder if someone can summarise for me the way in which Opensim
>> manages old inaccessible assets...
>
> From what I understand, nothing is done to old inaccessible assets.
> There is some difficulty in determining which assets are inaccessible.
> The reasons include:
>
> - assets can be referenced in scripts by UUID (so I heard)
> - assets may be referenced by regions not currently online
>
> In a grid where you control all the regions and databases, it should  
> be
> feasible to write a tool that can discover inaccessible assets.
>
>> I.e. if someone uploads a texture, perhaps uses
>> it on an object that is then deleted, and then delete a texture, is
>> it removed from the database... or can it persist and be there
>> forever?
>
> AFAIK the texture remains in the DB forever.
>
> Mike
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev

The University of St Andrews is a charity registered in Scotland : No  
SC013532