Subject | Re: [firebird-support] Re: Truncate table |
---|---|
Author | Markus Ostenried |
Post date | 2011-08-23T11:39:51Z |
On Tue, Aug 23, 2011 at 13:33, ck1625 <ch.kaufmann@...> wrote:
This should trigger garbage collection.
HTH,
Markus
> My problem is still there. It's only with FB 2.5; with FB 1.5 it is not that slow.Have you tried "SELECT Count(*) FROM <table>" ?
>
> 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.
This should trigger garbage collection.
HTH,
Markus