Syncronizing AD group memberships to/from SQL tables

Hi all,

I looking for other's feedback on a solution I am working on to sync the membership of an AD group to a combination of SQL tables.   The SQL tables are structured as follows:

Users Table

UserNameUserID
mcasey1
jdoe2
jsmith3

Group Table

Group NameGroupID
Important People4
Unimportant People5
Slightly Important People6

Group Members

GroupIDUserID
41
62
43

Initially i was attempting an AD group -> SQL 'group' sync by using a custom SQL select statement to structure the data so it looks like:

GroupIDMember
4mcasey;jsmith
6jsmith

I began testing powershell scripts so I can map the AD group 'member' attribute with the constructed SQL 'member' attribute.  I realized between the two that performance of the solution is less than ideal on both the SQL side and on the QC side.

Has anyone solved for something similar?  I'm open to any all all input.  The goal is to drive group memberships in a particular SQL based app via ARS.  Solving this would be a huge step forward for us.  Many thanks in advance!