Subject | RE: [firebird-support] Delete causes server to hang |
---|---|
Author | Leyne, Sean |
Post date | 2016-08-24T21:47:32Z |
> On my website i have a tabel where i log some web requests - aboutDo you have an index on "created"?
> 90.000/hour.
>
> Every hour this SQL is executed in a stored procedure:
> delete from requests where created < dateadd(-7 day to
> current_timestamp);
Sean