OpenDBX/Comparison - Revision history

Nose: removed backlink

2008-06-22T12:05:30Z

removed backlink

Nose: OpenDBX Comparison moved to OpenDBX/Comparison

2007-05-17T14:59:53Z

OpenDBX Comparison moved to OpenDBX/Comparison

Nose: header hierarchy

2007-05-06T16:28:01Z

header hierarchy

Nose: corrected links

2007-04-15T00:26:50Z

corrected links

Nose: /* Results */

2006-09-10T11:22:43Z

‎Results

Nose: /* Results */

2006-09-10T11:21:31Z

‎Results

Nose: /* Test description */

2006-06-25T21:04:11Z

‎Test description

Nose: OpenDBX - Comparison moved to OpenDBX Comparison

2006-06-25T21:01:54Z

OpenDBX - Comparison moved to OpenDBX Comparison

Nose at 20:57, 25 June 2006

2006-06-25T20:57:30Z

New page

__TOC__

= Comparison =

== Environment ==

The test environment consisted of two different machines both running [http://www.debian.org/releases/ Debian], the database server Debian 3.1 (Sarge) and the test machine Debian testing (Etch) with the latest official packages. The following software was used for the test:

; MySQL server: Version 4.1.11a
; MySQL client: Version 5.0.22
; OpenDBX : Version 1.1.1 ([http://www.linuxnetworks.de/opendbx/ more])
; LibDBI : Version 0.8.1 ([http://libdbi.sourceforge.net/ more])

MySQL was chosen because it is the one most often used and is best supported by both, OpenDBX and LibDBI. In addition it caches results for further queries using the same query string and therefore minimizes the impact of the database to this test.

One machine hosted the database server while the other was responsible for running the test:

; Database server : VIA C3 533MHz, 256MB RAM
; Benchmark client : Pentium M 1.5GHz, 512MB RAM

Both machines were connected by a 100MBit network and they were the only ones attached to the hub.

== Settings ==

All test were done with default settings for the MySQL database - no further optimizations were applied.

== Test description ==

To test the performance of each library (MySQL, OpenDBX, LibDBI) a small [http://www.linuxnetworks.de/opendbx/download/dbtest.c C test program] was written which establishes a connection to the database server once and performs a basic query 1 000 000 times in a row for each library. Most of the time is spent in the MySQL library, the server and their communication over the network. Differences in speed to the native MySQL implementation will show the overhead of the OpenDBX and LibDBI implementation.

The database contains only one table with one row:

CREATE TABLE odbxtest (
i8 tinyint,
i16 smallint,
i32 int,
i64 bigint,
f4 float,
f8 double,
string varchar(25)
) CHARACTER SET = utf8

INSERT INTO odbxtest VALUES (
100, 1000, 100000, 10000000,
10000.1, 10000000.1, 'first string' )

== Results ==

Below are the results for each run with the specified library. The values are the duration times in seconds until the test of each library was finished.

{|
|- style="background: #D0D0D0"
! style="width: 25%" | Library
! style="width: 25%" | MySQL native
! style="width: 25%" | OpenDBX mysql
! style="width: 25%" | LibDBI mysql
|- style="text-align: center"
! style="background: #D0D0D0" | 1. run
| 227
| 230
| 251
|- style="text-align: center"
! style="background: #D0D0D0" | 2. run
| 227
| 230
| 252
|- style="text-align: center"
! style="background: #D0D0D0" | 3. run
| 227
| 229
| 252
|}

== Conclusion ==

* The OpenDBX library is almost as fast as the native access to the MySQL library
* The LibDBI library is ca. 10% slower than the OpenDBX library

----
Back to [[OpenDBX|Overview]]

← Older revision		Revision as of 12:05, 22 June 2008
Line 76:		Line 76:
	* The OpenDBX library is almost as fast as the native access to the MySQL library		* The OpenDBX library is almost as fast as the native access to the MySQL library
	* The LibDBI library is ca. 10% slower than the OpenDBX library		* The LibDBI library is ca. 10% slower than the OpenDBX library
−
−
−	~~----~~
−	~~Back to [[OpenDBX\|Overview]]~~

← Older revision		Revision as of 16:28, 6 May 2007
Line 1:		Line 1:
	__TOC__		__TOC__
−
−
−	~~= Comparison =~~

	== Environment ==		== Environment ==

← Older revision	Revision as of 14:59, 17 May 2007
(No difference)

@@ Line 10: / Line 10: @@
 ; MySQL server: Version 4.1.11a
 ; MySQL client: Version 5.0.22
-; OpenDBX : Version 1.1.1 ([http://www.linuxnetworks.de/opendbx/ more])
+; OpenDBX : [[OpenDBX_Download_Historical|Version 1.1.1]]
-; LibDBI : Version 0.8.1 ([http://libdbi.sourceforge.net/ more])
+; LibDBI : [http://libdbi.sourceforge.net/ Version 0.8.1]
 MySQL was chosen because it is the one most often used and is best supported by both, OpenDBX and LibDBI. In addition it caches results for further queries using the same query string and therefore minimizes the impact of the database to this test.

@@ Line 52: / Line 52: @@
 Below are the results for each run with the specified library. The values are the duration times in seconds until the test of each library was finished.
-{| class="wikitable"
+{| class="wikitable" style="text-align: center"
 |-
 ! style="width: 25%" | Library
@@ Line 63: / Line 63: @@
 | 230
 | 251
-|- style="text-align: center"
+|-
 ! 2. run
 | 227
 | 230
 | 252
-|- style="text-align: center"
+|-
 ! 3. run
 | 227

@@ Line 45: / Line 45: @@
 , 1000, 100000, 10000000,
 .1, 10000000.1, 'first string' )
 == Results ==

← Older revision	Revision as of 21:01, 25 June 2006
(No difference)