On Aug 23, 2011, at 7:33 AM, "ck1625" <[email protected]> wrote:
> > > My problem is still there. It's only with FB 2.5; with FB 1.5 it is not that > slow. > > I thought, the solution is this: > DELETE FROM <table> > SELECT * FROM <table> > > But it looks like it doesn't work. It is still "random" when time is lost to > do For all versions of firebird, you have to commit after the delete and wait for all concurrent transactions to commit. If you are not doing both of those, the select (whether select * or select count) can not so the required garbage collect. Good luck, Ann >
