Skip to Content.
Sympa Menu

grouper-dev - Re: [grouper-dev] upgrade to 1.5 experience

Subject: Grouper Developers Forum

List archive

Re: [grouper-dev] upgrade to 1.5 experience

Chronological Thread 
  • From: Jim Fox <>
  • To: Shilen Patel <>
  • Cc: Chris Hyzer <>, "" <>
  • Subject: Re: [grouper-dev] upgrade to 1.5 experience
  • Date: Thu, 19 Nov 2009 16:24:44 -0800 (PST)

I suppose a real DBA would have known, but ANALYZE also can greatly
the efficiency of queries. After doing an analyze on the three
tables the
search with a user session is about the same as the root session.

We live and learn I guess. I'll add more groups and users to the
and see what happens.

Ok cool. Though I thought you said you ran analyze in your last
email. :) Did you have to run it more than once or did you run it
with different parameters the second time?

No. The problem is that I didn't realize the dramatic effect of analyze.

It only needed to be run once. And again, after any major additions to the tables.


Archive powered by MHonArc 2.6.16.

Top of Page