Subject Re: [firebird-support] Re: Truncate table
Author Markus Ostenried
On Tue, Aug 23, 2011 at 13:33, 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 the cleanup work.

Have you tried "SELECT Count(*) FROM <table>" ?
This should trigger garbage collection.

HTH,
Markus