[email protected] wrote: > but LDAP is a very limited database missing things like joins, views and a lot > of other things you can easily do with a SQL query
While you're right you don't recommend using joins for productive use, do you? > - don't blame the messenger > and just setup a wrapper fetching the data from LDAP and present them in a SQL > database for postfix Hmm, wouldn't it be better to sync the data with a local DB then? In this case you could transform the data in any lookup form needed which should get much better performance. > did something similar recently for a inbound mail-gateway by fetching data > from a infinite count of final destination servers each with it's own mysql > configuration and present them on the gateway server including the transport > table with the target machines > > that's finally a cronjob running every 5 minutes - such data don't change > every second Hmm, running a CRON job every 5 minutes which does almost nothing is a waste of resources when data sets are big. In case of OpenLDAP as data source one could write a syncrepl client. Food for thought: Following DN reference attributes with additional LDAP lookups is not very performant either. With OpenLDAP's slapo-deref postfix could use the deref extended control [1] to fetch referenced entries with one query. Ciao, Michael. [1] http://www.openldap.org/devel/gitweb.cgi?p=openldap.git;a=blob_plain;f=doc/drafts/draft-masarati-ldap-deref-xx.txt;hb=HEAD
smime.p7s
Description: S/MIME Cryptographic Signature
