Performance Comparisons with Relational Databases

Background

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 
WHERE VALUETABLE.PARENTID=GLUESA.ID 
  AND VALUETABLE.TYPEID = TYPETABLE.TYPEID 
  AND TYPETABLE.NAME ='GlueSAAccessControlBaseRule' 
  AND VALUETABLE.VALUE='lhcb'
LDAP query for API Test:
ldapsearch -x -LLL -h lcg-bdii:2170 -b o=grid '(&(objectClass=GlueSA)(GlueSAAccessControlBaseRule=lhcb))'

Test Results

Oracle

ClientComparison.png

All client implementations use the Oracle libs available from AFS.

MySQL

ClientComparison_mixed.png

Medium Response Size

Comparison_Full_MediumDataSize.png

Large Response Size

Comparison_Full_BigDataSize.png

The Response Size significantly differs between LDAP and the relational model

Topic attachments
I Attachment History Action Size Date WhoSorted ascending 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  

This topic: EGEE > InformationSystem > RelationalComparison
Topic revision: r1 - 2009-01-12 - LaurenceField
 
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