Pearson's HE Portal is going to be going to uPortal 3.1.x soon and we have been doing some performance testing. The only issue I've ran into was in the event that all users were users new to uPortal. The problem was not that uPortal 3.1.x did not handle the load, but that it did so a good deal slower than uPortal 2.6.1. In spite of that my laptop was able to handle 600 concurrent users which resulted in 18k new logins in roughly a half hour. I have a patch which will be uploaded some time today or tomorrow which significantly narrows the gap between uPortal 2.6.1 and uPortal 3.1.x. What the patch impacts is the same for all uPortal 3.x versions from 3.0 to present. With this patch, uPortal is fast enough to meet Pearson's needs. I do think that there is some further room for performance improvement, but since uP3 is now 'fast enough' it is unlikely I'll get the time to make further improvements. As far as missing indices... I've noticed that the same indices that were missing in older versions of uPortal appear to be missing in the newer. For example, no index on USER_NAME in the UP_USER table. Many institutions probably have no need for that index though. For Pearson, we can have upwards of 14+ million users, and tend to end up adding indices that would not be necessary elsewhere. In my experience, if you aren't dealing with nothing but new users, the limiting facter is rarely the portal, and typically the portlets (that is unless uPortal has not been configured/tuned properly).
-Lennard ----- Original Message ----- From: "Benito J. Gonzalez" <bgonzal...@ucmerced.edu> To: uportal-dev@lists.ja-sig.org Sent: Monday, August 23, 2010 8:36:27 AM GMT -07:00 U.S. Mountain Time (Arizona) Subject: [uportal-dev] uPortal 3.2.2 load issues Hi All, Has anyone had performance issues with the latest release under load? We see a large difference in performance between our current 3.0.2 release and 3.2.2. CPU and memory usage were low. My guess is there are missing indices. We did some optimization of our 3.0.2 db but no optimization of 3.2.2. Any other ideas to check? Thanks, -- Benito J. Gonzalez Manager, Enterprise Web Application Development Information Technology Department University of California, Merced Desk: 209.228.2974 Cell: 209.201.5052 Email: bgonzal...@ucmerced.edu -- You are currently subscribed to uportal-dev@lists.ja-sig.org as: lful...@unicon.net To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev -- You are currently subscribed to uportal-dev@lists.ja-sig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev