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] Re: Very long transaction start after deleting a big number of records.

2014-07-28 Thread brucedickin...@wp.pl [firebird-support]
Thanks guys. 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.