Re: [firebird-support] Re: Very long transaction start after deleting a big number of records.

2014-07-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 29, 2014, at 12:26 AM, brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: I haven't thought about scanning all the rows with SELECT after DELETE but it might be something. Perhaps FB 3.0 will help us with this. Doing the select in the same transaction

[firebird-support] Why nbackup takes very long time for 40G database

2014-07-30 Thread Xifeng Wen xif...@nortek-as.com [firebird-support]
Hi all I hope I can get help from somebody. I really like the easy-to-use firebird. We have a firebird database which has been deployed for 4 years. It is reliable and now its size becomes 40G. We have several Windows services (4 or 5 ), they frequently interact with this database,

[firebird-support] RE: Why nbackup takes very long time for 40G database

2014-07-30 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Recently I find the nbackup is very very slow. For my 40G database, it takes almost 24 hours to finish the 0 level, for the rest levels it also takes several hours. NBackup should run at near raw HDDs performance levels -- 100mb/s. Does anyone know what is the normal time consumption for

Re: [firebird-support] RE: Why nbackup takes very long time for 40G database

2014-07-30 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 08:44 a.m. 31/07/2014, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: Please check the v2.5.2 and v2.5.3 release notes, there were some bug reported where nbackup got hung which were fixed in those releases. Esp. 2.5.3, which has had some major work to reduce the time