> 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
Hello kragh.tho...@yahoo.com,
Thursday, August 25, 2016, 8:00:28 AM, you wrote:
> 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
Which Firebird version are you using, and do you use Super, Classic or
SuperClassic?
Mark
- Bericht beantwoorden -
Van: "kragh.tho...@yahoo.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Delete causes server to hang
Datum: wo, aug. 24, 2016 22:00
HeyOn my website i have a
Hey Helen Thanks for hour reply, let me see if i can clarify the problem, the
actual delete of the 90.000 rows is not the problem, this completes in 10-30
seconds. That is just fine, performance does not matter here.
I have 2 web servers, on each of them, there is a background thread that
On 26/08/2016 07:32, kragh.tho...@yahoo.com [firebird-support] wrote:
From my perspective it looks like the delete of the 90.000 rows
results in a complete hang/standstill on the database server. In those
few seconds i looks like FB does not finish any statements.
How is the garbage collecti
Hey Tim
The code does not do anything active, but we run backup 4 times a day.
I have tried batching the delete, so that one batch runs in a autonomous
transaction, and made at count on the table after each batch, but with no luck.
The idea was to reduce the number of deleted rows that the ga
Hi Thomas,
9 records versions is not that big amount to slow down Firebird
completely for 30 seconds.
In this old article below we made tests with updating/deleting 1mln of
records, but it was much faster than you describe.
http://ib-aid.com/en/articles/negative-impact-of-indices-to-inse
> Anyway, right now there is not enough information - to investigate it, run
> gstat -r -t < tablename > stat.txt
Additionally, use gstat and extract the header page stats.
This will allow for the OAT, OIT, and current transaction to be reviewed, and
check the sweep interval setting.
Sean
ird-support] Delete causes server to hang
Hey Tim
The code does not do anything active, but we run backup 4 times a day.
I have tried batching the delete, so that one batch runs in a autonomous
transaction, and made at count on the table after each batch, but with no luck.
The idea was to red
beleve that rows affect this query but i can be
wrong
i supopose that it process all records not 1000
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Friday, August 26, 2016 10:27 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support]
10 matches
Mail list logo