Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote:
> Hi all,
> Firebird v2.5.6 - superserver. Windows 10 x64.
> I was making some changes to a database when I noticed a query
> like this:
> SELECT TEXTBLOB
> FROM TABLEA WHERE TEXTBLOB CONTAINING 'SOME TEXT'
> was suddenly
> 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
Hey
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);
This results in about 90.000 deleted rows.
However, after the statement