Grouper Developers Forum

[Mark Weber <>]

Issue #1 (UI related)
---------------------
One inefficiency/bug I want to point out with the UI and how it 
paginates result sets.  If I am displaying the members of a group with a 
given privilege and there are 1,000 members in that group the UI 
displays 10/25/50/100 results at a time.  However, for each new page 
request it re-requests the entire result set.

I think this is incorrect because new members may show up in between 
page requests and cause erroneous or confusing results between page 
requests.  (i.e. they may see the same person on page 1 as they do on 
page 2 depending on the quantity of changes between page requests)

It's inefficient because in the case of 1000 members, at 50 results per 
page, it produces about 20,000 queries before I reach the last page.

If it's going to capture the entire result set it ought to store it, 
sort it and paginate it.  And it should also allow for the user to 
"refresh" the results (thus implying the results are point-in-time)...IMHO.


Issue #2 (Back-end)
-------------------
My trials led me to Hibernate's front door and our DBA is out this week 
so we're having trouble getting some hard numbers.  But something looks 
askew.  I thought it might be something with Oracle or something 10g 
specific?? I analyzed the tables tried adding different indexes etc... 
nothing made a dent.  Next week we will be able to see specific activity 
for a given connection alongside the SQL it's attempting to execute.

So, in the meantime, I decided to switch out back-ends and use MySQL on 
localhost.  Page loads for displaying privilegee's (50 members) went 
from 124 seconds down to 23 seconds.  Better, but not yet acceptable. 
The fact that it's on localhost is probably the reason for the speed 
increase.

I'm going to try creating different groups with different permissions to 
see if I can spot something obvious.  Maybe it's just having trouble 
displaying a group where every member has every privilege??


--
.Mark G. Weber----------------------Division of Information Technology.
|
            University Of Wisconsin - Madison|
|608/263.8945                               Room 3159 Computer Science|
`---------------------------------------------------------------------'

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature