[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
poor performance of Openldap/Pgsql-7.4.1
Hi
I installed OpenLDAP-2.2.11/PgSQL-7.4.1 on Solaris9.
After I added one thousand entries, although I tuned up parameters of postgresql.conf,
used directorymark tool to test the performance of ldapsearch, the results was only
1.7ops. It was very poor.
(By back-bdb with same entries, I got 387.8ops. )
Information of my entries like:
------------
dn: cn=zhang(0-1000),o=sql,c=RU
objectClass: top
objectClass: inetOrgPerson
cn: zhang(0-1000)
sn: pu
o: sql
uid: (0-1000)
mail: zhang@sql.com
employeeNumber: (0-1000)
I used all of default sql files under /back-sql/pgsql/ to create the data store, but
only added one line in testdb_create.sql as below.
------------
CREATE UNIQUE INDEX PK_authors_docs ON authors_docs (pers_id,doc_id);
Has anybody gotten high performance by postgresql?
Would you please give me suggestions?
Another question:
Does back-sql support all of matching rules of RFC?
Thanks & regards
+------------------------------------------------------------+
Fujitsu Hokuriku Systems Software Enterprise Oketani Project
Zhang Pu zhang@fjh.fujitsu.com