Performance Comparisons with Relational Databases


In order to populate a relational database with information from LDAP it is first necessary to translate the information schema. After the relational database has been created information can be extracted from the LDAP database, translated and added to the relational database.

Test Environment

MySQL (version 5.0.45) database and a native LDAP client. The OpenLDAP (version 2.2.13) and MySQL server run on the same hardware (SLC 4.5, Xeon 2.4Ghz, 1GB Memory). The Oracle RAC (Real Application Cluster) instance consits of two nodes with a replicated database.

Test Description

The first set of tests evaluated the response times for different API implementations. The following queries were used.

SQL Query for API Test:

SELECT * FROM GlueSA, ValueTable, TypeTable 
  AND TYPETABLE.NAME ='GlueSAAccessControlBaseRule' 
LDAP query for API Test:
ldapsearch -x -LLL -h lcg-bdii:2170 -b o=grid '(&(objectClass=GlueSA)(GlueSAAccessControlBaseRule=lhcb))'

Test Results



All client implementations use the Oracle libs available from AFS.



Medium Response Size


Large Response Size


The Response Size significantly differs between LDAP and the relational model

Topic attachments
I Attachment History Action Size Date Who Comment
PNGpng ClientComparison.png r1 manage 43.8 K 2009-01-12 - 11:02 LaurenceField  
PNGpng ClientComparison_mixed.png r1 manage 35.9 K 2009-01-12 - 11:02 LaurenceField  
PNGpng Comparison_Full_BigDataSize.png r1 manage 34.1 K 2009-01-12 - 11:02 LaurenceField  
PNGpng Comparison_Full_MediumDataSize.png r1 manage 38.4 K 2009-01-12 - 11:02 LaurenceField  
Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2009-01-12 - LaurenceField
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    EGEE All webs login

This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright & by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Ask a support question or Send feedback