Hi Arvīds, Thanks for referring us back to your very helpful blog post. We have looked at your post before, but somehow we managed to overlook the advice regarding transactional annotations. We will feel much more confident it removing those annotations now.
Thanks Sean From: [email protected] [mailto:[email protected]] On Behalf Of Arvids Grabovskis Sent: 02 July 2012 15:25 To: [email protected] Subject: Re: [uportal-dev] uPortal 4.0.5 performance problems with transaction annotations I assume that you're using MSSQL as DBMS, because I had the same problem as you described. Thread that you referenced, might be more related to login time performance (person attribute retrieval, group membership calculation, session initialization, etc.). If you're using MSSQL, you can visit blog post describing my experience: http://doginpool.blogspot.com/2012/03/deploying-uportal-403.html (It is referenced from manual as "Indexes for performance", but in fact covers a bit broader topic). -- Arvīds 2012/7/2 Sean Reed <[email protected]<mailto:[email protected]>> We are running uPortal 4.0.5 in pilot at the moment here at UWE and we have been experiencing serious performance issues, as described by my colleague Sarah Sloan in the following post : http://jasig.275507.n4.nabble.com/uPortal-4-performance-compared-to-uPortal-2-td4654203.html After much investigation we believe the problem lies with transaction handling in the following classes: JpaPortletDefinitionDao and JpaPortletEntityDao. I found that the ‘@Transactional(readOnly=true)’ annotation was causing (what I believe to be) unnecessary transactions to be used around methods which only read from the database. The following information helped me understand the correct use of this annotation: http://www.ibm.com/developerworks/java/library/j-ts1/index.html (*Listing 8*) Removing these annotations from uP4 results in page renders running between 100% and 200% faster, at least according to our benchmarks, and on our Solaris servers. The removal of these annotations appears safe to me, any advice/comments from the community gratefully received. Sean Reed UWE UK -- You are currently subscribed to [email protected]<mailto:[email protected]> as: [email protected]<mailto:[email protected]> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
