> This is so loaded. Postgresql is entirely configurable and in the long
Thanks, been a PostgreSQL DBA for a decade now. > run, when you're dealing with hundred's of thousands of records, > postgresql is going to out perform any local text based db file. Only back-hdb/back-dbd are *NOT* "local text based db file". They use Berkley DB, and *YES* they are faster than PostgreSQL. Period. OpenLDAP back-hdb is about the fastest thing you can find, anywhere. Of course, back-hdb/back-dbd don't need to support every crazy thing that a full-blown SQL RDBMS does. > If you're postgresql database system is configured correctly you'll see no > difference with small amounts of records between the two methods, Disagree; BUT performance can be entirely acceptable. You also loosing performance in the transport between the driver and the database. > it's > when your data becomes significantly large, that postgresql will blow away > the local db file. No, it won't. If your OpenLDAP database gets slow as its DB gets big then you need to attend to your DB_CONFIG file.
