Re: [Sqlgrey-users] SQL Query optimization

[Michel B. <mi...@bo...>]

Le Dimanche 20 F=E9vrier 2005 00:30, Klaus Alexander Seistrup a =E9crit :
>
> > There's little chance, if any, that the same SQLgrey DB would be used
> > by several servers on different timezones, so why use GMT...?
>
> I was thinking that backup MXes might use the same database as the
> primary MX, and they might be in different timezones.

They would probably not use the database directly, but maybe indirectly t=
hru=20
using the same SQLgrey server. The timestamps are then the "internals" of=
 the=20
SQLgrey server, and are not known to the MXes.

> What happens to localtime() timestamps (and intervals) as we pass from
> standard time to daylight saving time?

Not much. Addresses in AWLs may be kept one hour more or less than planne=
d=20
(let's say 1 month +/- 1 hour instead of 1 month), which doesn't really=20
matter, does it ?

Addresses in connect will be kept waiting for a reconnection for 1 more/l=
ess=20
hour, which shouldn't have a big incidence either.

What may be more noticeable is that, at the time the DST changes (in the=20
middle of the night) the "minimum time before accepting reconnection" may=
=20
become one hour longer, or not enforced at all, for one hour.

The practical consequences for this will be IMHO insignificant.

Cheers.

--=20
Michel Bouissou <mi...@bo...> OpenPGP ID 0xDDE8AC6E