Revision: lcg-foundation-interface--devel--0--patch-3
Archive: lorentey@elte.hu--2004
Creator: Karoly Lorentey <lorentey@elte.hu>
Date: Tue Mar 15 17:38:18 CET 2005
Standard-date: 2005-03-15 16:38:18 GMT
Modified-files: setup.sql
    src/ch/cern/lcg/registration/Experiment.java
New-patches: lorentey@elte.hu--2004/lcg-foundation-interface--devel--0--patch-3
Summary: Improve query performance.
Keywords: 

* src/ch/cern/lcg/registration/Experiment.java (getExpiredMembers)
  (getMembersById, matchMembers): Insert into QUERY, not separate tables.
  (matchMembers): Fill in person_ids from email addresses in a separate update.
  (private matchMembers): Improve query performance (no more full table lookups
  on VOMS_PERSONS).