Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Re: Databases being used with Grouper?

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: Databases being used with Grouper?

Chronological Thread 
  • From: "Waldbieser, Carl" <>
  • To: Karthik Doppala <>
  • Cc:
  • Subject: [grouper-users] Re: Databases being used with Grouper?
  • Date: Mon, 15 Sep 2014 14:38:27 -0400 (EDT)


Thanks! That is good to know.
Do you have any particular leanings toward Oracle or MySQL at this point?


----- Original Message -----
From: "Karthik Doppala"
To: "Carl Waldbieser"

Sent: Monday, September 15, 2014 2:04:56 PM
Subject: RE: Databases being used with Grouper?

Hi Carl,
We at UCLA have been using MS Sql Server for almost a year now and we have
had a lot performance issues, we also observed that there was a data type
inconsistencies (for most of the queries the data type nvarchar is currently
being converted to varchar causing index suppressions which further results
in table scans). We fined tuned our DB but still do not have an acceptable
performance while loading our 1.7 million memberships. Based on my experience
I would not recommend MS Sql Server, In fact we are planning to switch to
Oracle or MySql soon.


-----Original Message-----

On Behalf Of Waldbieser, Carl
Sent: Monday, September 15, 2014 9:50 AM

Subject: [grouper-users] Databases being used with Grouper?

At Lafayette College, we are gearing up to do a limited Grouper pilot. One
of the questions that has come up during planning is, "What kind of database
backend are folks actually using with Grouper?" I'd be interested in knowing
a bit about the type of databases deployed in production Grouper settings,
and something that would give us an idea about the scale of the subjects,
groups, and memberships being managed. This information would be useful for
us as a starting point.

Carl Waldbieser
ITS System Programmer
Lafayette College

Archive powered by MHonArc 2.6.16.

Top of Page