[Opensim-dev] Opensim database management - garbage collection

[Mike Mazur]

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