[firebird-support] Re: Best way to delete millions of rows

Hey Vlad The table has 4 index, one from a primary key, another from a foreign key, and 2 on other columns. The system is a virtual machine with 8 Gb of ram, page size is 16K and page buffers 512. The IO sub system is a Dell DAS, with 16 SAS 15K disks in raid 10. Our sysadmin ran a test on

RE: [firebird-support] On Connect triggers are dangerous, aren't they?

<> gbak -nodbtriggers - Suppresses Database Triggers from running [Firebird 2.1] Regards Paul Beach

Re: [firebird-support] On Connect triggers are dangerous, aren't they?

01.11.2016 15:59, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I wonder is there mechanism to prevent this trigger become dangerous. E.g. if > there is the > slightest chance that error will be thrown in the on connect trigger then the > database > will be completely unavailable.

[firebird-support] On Connect triggers are dangerous, aren't they?

Hi! I am reading message Yahoo! Groups https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876 https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876 Yahoo! Groups

[firebird-support] Re: Best way to delete millions of rows

Hi Thomas, only from curiosity: what is your filesystem? I had a similar issue some time ago, when we used an OpenSuse with btrfs. After switching to ext4 everything was ok. I never investigated the problem deeper, but I think it could be the snapshot feature of btrfs that has slowed down the

[firebird-support] Re: Best way to delete millions of rows

> ---In firebird-support@yahoogroups.com, wrote : > > Hey Vlad > If i only count the deleted rows, the problem is the same, and > > the server hangs while performing garbage collection. Sad. Probably, table have a lot of indices ? IO subsystem, amount of RAM, page size