Subject Re: Update take hours to delete records :(
Author karolbieniaszewski
--- In firebird-support@yahoogroups.com, "nathanelrick" <nathanelrick@...> wrote:
>
> > Update Session Set
> > data=...
> > Expiry_date= NOW + 15minutes
> > where
> > id=... and
> > Date_expired > DATEADD(-5 minute to CAST('now' AS TIMESTAMP))
>
> ok, in fact we already do like this, but by 1 minute instead of by 5 minutes ... :(
>

one question
how offen do you run sweep?

Karol Bieniaszewski