Re: [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 <sda...@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@lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev

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

smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Opensim-dev mailing list
Opensim-dev@lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev