We recently migrated from Tridion 2011 to SDL WEB 8.5 and suddenly, in one of our environments (staging), an specific page started to take over 2 hours to being published.
This page has a tbb c# which gets information about a lot of components and check if the page which uses each component is published in the current target.
Usually, publishing the page last 10 minutes, but now, is taking too long and we get time out(this is happening only in staging, in dev environment, with the same amount of components, the page gets published good)
Yesterday I did a test, removing this verification, and the page was published in 10 minutes, also I debugged and getting the information if each page is published or not (PublishEngine.IsPublished()) takes over 4 secs.
Just in case, the syntax we are using is:
PublishEngine.IsPublished(localPage, pubTarget, true)
Can I do some index or cleaning to improve the performance ?
thank you !! Carolina