Sitecore – property change events flooding the Event Queue in the Core database
source link: https://blog.coates.dk/2015/05/19/property-change-events-flooding-the-event-queue-in-the-core-database/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Sitecore – property change events flooding the Event Queue in the Core database
I had an issue that the EventQueue table in the Core database which was being flooded with events, which in turn was responsible for causing bad performance.
This was caused by the fact that each time the Lucene indexes are updated Sitecore raises the database:propertychanged event.
The default implementation subscribes to the event and adds it to the EventQueue table in the core database. I set the “Days To Keep” events to 1 day – but it still inserts over 100000 events a day
Sitecore have registered this as a bug, but as yet there is no fix for 7.5 or 8.
Solution
This is not very nice at all, but it was the best we could do as a workaround for this issue. The credit for this solution must go to my colleague Peter Wind (@peterwind) who is created the hack!
Use reflector to get the code for the default Sitecore.Eventing.Remote.RemoteEventMap class (defined in Sitecore.Kernel.dll), and create your own class, see below.
Modify the SetupGlobalEventSubscribers function, so you subscribe to the database:propertychanged event – but do not add the event to the EventQueue, see below.
The last step is to update the configuration in the web.config to use your new and improved class.
note: I have the support case number in the namespace & DLL name – so when the bug is fixed, I can remove this code and in addition any other developer at Pentia can see the history related to this support issue and why I have done such a nasty fix.
Anyway I hope this helps somebody out there
Post navigation
← Sitecore SPEAK Insert Link Dialog – missing icons & sitecore tree – Don’t panic, U didn’t break it!!!! Sitecore History Table – how to control how long the entries are kept? →2 thoughts on “Sitecore – property change events flooding the Event Queue in the Core database”
-
James Walford September 25, 2015 at 08:51
Hi Alan,
Is there a public issue number for this? I’m trying to find the root cause of a huge increase in recycle time since a 7.2 update 2 -> 7.2 update 4 and am trying to find out if this is something we’ve introduced.Reply ↓-
I’m on holiday but last time I checked there was no fix, when I get back I will find the public issue number
Reply ↓
-
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK