|Subject||Re: [firebird-support] Re: Truncate table|
On Aug 23, 2011, at 7:33 AM, "ck1625" <ch.kaufmann@...> wrote:
>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.
> 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