| Subject | Re: [firebird-support] Re: Best way to delete millions of rows |
|---|---|
| Author | liviuslivius |
| Post date | 2016-11-22T08:30:45Z |
Hi,
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.
regards,
Karol Bieniaszewski
W dniu 2016-11-22 09:18:50 użytkownik kragh.thomas@... [firebird-support] <firebird-support@yahoogroups.com> napisał:
HeyI 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@...