Subject Re: [firebird-support] Re: Best way to delete millions of rows
Author liviuslivius
i agree with you
i suppose that time spend by GC should be measured and if it take to much time
then stop GC and try again leter.
E.g. when i do delete from milions_table
and then do SELECT COUNT(*) form milions_table
it should not clear whole garbages and stop query until GC finished.
e.g. if GC spend 1 seconds, it should stop taking this execution anymore
and my SELECT COUNT(*) form milions_table should run now without GC actions.
Karol Bieniaszewski
W dniu 2016-11-22 09:18:50 użytkownik kragh.thomas@... [firebird-support] <> napisał:

I know that this will trigger garbage collection. However i don't believe this is expected behavior, when a action from one user crashes the entire server and causes the server to be unresponsive for 1-5 minutes while GC is running, even users on other databases on the same server is affected by this. 


Posted by: kragh.thomas@...