Developer forum

Forum » Development » Weird performance issue in 19.2.2.4

Weird performance issue in 19.2.2.4

E-mail notifications
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Posted on 23/05/2011 16:38:02
Hi there,

I am trying to upgrade a (staging) server from 19.1.something to the latest version. I installed 19.2.2.4 but then ran into major performance issues. I just downgraded to 19.2.2.3 and it seems to be fine again.

On a closer inspection using SQL Server Profiler, I found that 19.2.2.4 is executing many requests for the page tree. E.g. not something like SELECT * FROM Page but something like SELECT * FROM Page WHERE SomeIdColumn is SomeId. This query is executed many times, causing the W3P worker process to take more than 50% for a long time. This in turn results in timeouts, and broken trees in the backend. I could be wrong about the actual table names that are used in the queries. Since I switched back to 19.2.2.3, I can no longer check it.

Known issue with this release?

Imar

Replies

 
Nicolai Høeg Pedersen
Posted on 23/05/2011 19:58:45
Reply
Could be 6530:
http://developer.dynamicweb-cms.com/Releases/Dynamicweb-7.2/Bug-fixes-7.2.3-%28SR3%29.aspx

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 24/05/2011 08:31:27
Reply

Yeah, that could very well be it, thanks.... That version is not available for download, is it? And if it isn't, should it be available? What's the reasoning behind the different available versions for download? Feels dangerous to have 19.2.2.4 as the "latest stable release" ;-)

Imar

 
Nicolai Høeg Pedersen
Posted on 24/05/2011 09:06:00
Reply
The new hotfix is now available...

 

You must be logged in to post in the forum