[Date Prev][Date Next] [Chronological] [Thread] [Top]

replicating back-sql data


We are using back-sql to point to a sybase database. ldap_entries is a view of about 40,000 entries. It's working ok. Unfortunately, every time a search like this is executed:

ldapsearch -H ldaps://xx.uen.org -D uid=bmidgley,dc=my,dc=uen,dc=org -x -W -d 256 -z 10 "(uid=bmidgley)"

It looks like the backend selects all records from ldap_entries. It takes about 6 seconds on our fastest db server.

Is there a way to replicate this back-sql data into a traditional openldap backend to improve performance? I know slurpd needs a log so that won't work. Is there anything out there that will just do a brute force push from one ldap db to another? I think this would be more reasonable than constant heavyweight user lookups. We could deal with some lag time in the updates.

BTW, we have several web apps that use the sybase data so unfortunately we have to stick with it being the definitive database.