Subject | Re: Update take hours to delete records :( |
---|---|
Author | karolbieniaszewski |
Post date | 2012-02-29T11:34:18Z |
--- In firebird-support@yahoogroups.com, "nathanelrick" <nathanelrick@...> wrote:
how offen do you run sweep?
Karol Bieniaszewski
>one question
> > 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 ... :(
>
how offen do you run sweep?
Karol Bieniaszewski