November Happy Hour will be moved to Thursday December 5th.
November Happy Hour will be moved to Thursday December 5th.
How many rows do you have in ecfVersion? Can you get the execution plan for this query?
We have 479098 rows in the table.
How do I get the execution plan, I did it once but have forgotten! :-)
/Kristoffer
This is excuted:
I found something interesting, but I'd have to verify them more closely before filing a bug for us to work on it.
How long does it take for you to run that query? Is it possible to reduce the batch size?
My suspicion is on your ecfVersion.IDX_ecfVersion_Indexed_ContentId Index. Make sure it gets defragmented, and its statistics are up-to-date
The query took 2 minutes 23 seconds.
Tried to run this:
declare @p1 dbo.udttObjectWorkId insert into @p1 values(96265,0,1358777,NULL) exec ecfVersion_ListByWorkIds @ContentLinks=@p1
I have rebuilt all the indexes on ecfVersion and updated statistics but it still takes 2 minutes.
Should I email developer support with a link to a database backup?
/Kristoffer
Yes, that should be the proper way to handle it. It might end up in my hands eventually - as I'm generally excited for performance improvements - but we should follow the workflow
Ticket has been created and it would be great if you can look at this as soon as possible since our customer cannot work in Commerce edit mode right now. If you have any other idea how we can work around this for now. Maybe delete old versions or something, that would be great!
Thanks!
/Kristoffer
http://vimvq1987.com/2017/10/curious-case-sql-execution-plan/
This might be of interest to you
Another update:
http://vimvq1987.com/2017/10/curious-case-sql-execution-plan-part-2/
we will incorporate these changes in an upcoming version
Hi Quan!
Today we got an exception in this function:
Mediachase.Commerce.Catalog.CatalogContent.CatalogContentSync.CreateDraft(CatalogNodeDto nodeDto, String changedBy)
It looks like it was this procedure that caused the timeout:
ecfVersion_SyncCatalogData
Also an ecfVersion procedure. Maybe there is something there that also needs to be updated?
/Kristoffer
Hi!
This just showed up in our logs. Same code has been running for a long time now without problems.
Any idea what could cause this problem? We are running Commerce 10.5
Thanks!
/Kristoffer