Subject RE: [firebird-support] Delete causes server to hang
Author Leyne, Sean
> On my website i have a tabel where i log some web requests - about
> 90.000/hour.
>
> Every hour this SQL is executed in a stored procedure:
> delete from requests where created < dateadd(-7 day to
> current_timestamp);

Do you have an index on "created"?


Sean