On Aug 23, 2011, at 7:33 AM, "ck1625" <ch.kaufmann@...> 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

>