Re: [firebird-support] Re: Best way to delete millions of rows

 

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@yahoo.com [firebird-support] <firebird-support@yahoogroups.com> napisał:

 

Hey

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@yahoo.com

---

 

__._,_.___

---

Posted by: liviuslivius <liviuslivius@poczta.onet.pl>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (19)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 7

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___