[wp-hackers] Re: Sqlite

Robert Deaton false.hopes at gmail.com
Fri Jun 24 18:01:23 GMT 2005


Storing just a unix timestamp and the offset means more parsing every
time dates need to be seen, instead of just once and throwing it into
the database.

On 6/23/05, Kimmo Suominen <kimmo+key+wordpress.c4f53f at suominen.com> wrote:
> On Thu, Jun 23, 2005 at 11:14:56AM +0200, Martin Geisler wrote:
> > Kimmo Suominen <kimmo+key+wordpress.c4f53f at suominen.com> writes:
> >
> > > AFAICT the big reason for both "local" and GMT (equivalent of
> > > seconds since unix epoch) times in the database is permalink
> > > support. The local time is needed to keep the permalinks from
> > > changing.
> >
> > That doesn't mean that one couldn't use a Unix epoch timestamp: store
> 
> I wasn't saying that seconds from epoch timestamps cannot be used.
> The message I replied to seemed to suggest a single timestamp, which
> is the issue I was addressing.
> 
> Storing a unix timestamp and the offset from gmt on each post would
> achieve the same result as the current two timestamps.
> 
> Regards,
> + Kimmo
> --
> <A HREF="http://kimmo.suominen.com/">Kimmo Suominen</A>
> 
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
> 


-- 
--Robert Deaton
http://somethingunpredictable.com


More information about the wp-hackers mailing list