Re: [firebird-support] Delete causes server to hang

7 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Delete causes server to hang Hey TimThe 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 t

Re: [firebird-support] Delete causes server to hang

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

RE: [firebird-support] Delete causes server to hang

> 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

Re: [firebird-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 reduce the number of deleted rows that the

Re: [firebird-support] Delete causes server to hang

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

Re: [firebird-support] Delete causes server to hang

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

Re: [firebird-support] Delete causes server to hang

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

RE: [firebird-support] Delete causes server to hang

> 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