Subject | Re: Transactions and cleaning up of rows after a massive deletion |
---|---|
Author | fernnaj |
Post date | 2011-10-25T21:10:02Z |
> Yes, each connection gets a time-slice to run, then stops and waits forThat makes a lot of sense.
> other threads to run.
> [...] when Firebird SuperServerOh! If it's not rats, I will then need to check what is making that strange noise inside my computer! :-)
> 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.
> > would my plain "insert into ()I see... a lot of testing time ahead of me!
> > 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.
Thank you very very much for your time and answers, Ann. You've been very helpful!
Best regards, Fernando