Subject Re: Transactions and cleaning up of rows after a massive deletion
Author fernnaj
> Yes, each connection gets a time-slice to run, then stops and waits for
> other threads to run.

That makes a lot of sense.

> [...] when Firebird SuperServer
> is heavily loaded, the garbage collect thread doesn't get enough time to run
> and garbage builds up, gradually to the point that it affects performance.
> Fortunately, it doesn't attract rats.

Oh! If it's not rats, I will then need to check what is making that strange noise inside my computer! :-)

> > would my plain "insert into ()
> > values ()" query "provoke" the garbage collection?
> >
>
> I don't know. There may be some interaction with indexes that causes it to
> look at other records.

I see... a lot of testing time ahead of me!

Thank you very very much for your time and answers, Ann. You've been very helpful!

Best regards, Fernando