[Opensim-dev] Opensim database management - garbage collection

[J Ross Nicoll]

Good to know. As long as there's a reason, I'm happy, I just want to  
make sure people have thought about it, thanks for the answer!

On 17 Jan 2009, at 07:36, Mike Mazur wrote:

> Hi,
>
> On Fri, Jan 16, 2009 at 9:46 PM, Sean Dague <sdague at gmail.com> wrote:
>> J Ross Nicoll wrote:
>>> 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?
>>
>> Because storing time as number of seconds since epoch is a tried and
>> true technique, and is used throughout the opensim source base, so is
>> consistant with how it is done elsewhere.
>
> Another reason I can think of is that an integer is supported
> identically in most (all?) databases. The datetime datatypes may be
> different, making data migration from SQLite to MySQL a little more
> complicated, for instance.
>
> 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



-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20090117/4666dc30/attachment-0001.bin>