HOB performed a test in order to measure the amount of data exchanged between SQL databases and their clients.
Databases used in the test:
1. IBM DB2 UDB Version 5.0 for Windows NT
2. Oracle for Windows NT Version 8.0
3. Microsoft SQL Server Version 7
The IBM DB2 database and Microsoft SQL Server ran on Windows 2000 Beta 3, whereas the Oracle database was installed on Windows NT 4.0. We found no dependencies of the underlying operating system. The protocol used for communication was TCP/IP in all cases.
On the client side, a PC with Windows NT 4.0 was used. The application tested used no ODBC, it used the database specific client software.
We believe, the results would have been nearly the same if we would have used ODBC. To measure the amount of data exchanged, we started a SELECT statement with a result set of 28 columns and 10,000 rows. We believe such a SELECT is a typical application for remote access to databases.
Of course, in all databases compared, there were exactly the same data.The tests showed the following results:
1. IBM DB2, protocol DRDA:
Records sent by the client:
123
Bytes sent by the client: 15,064
Records sent by the server: 1,307
Bytes sent by the server: 2,543,800
--- total bytes send:
2,558,864
2. Oracle 8.0, protocol SQL*Net:
Records sent by the client:
123
Bytes sent by the client: 15,064
Records sent by the server: 1,307
Bytes sent by the server: 4,349,560
--- total bytes send:
4,364,624
3. Microsoft SQL Server 7
Records sent by the client:
11
Bytes sent by the client:
1,024
Records sent by the server:
307
Bytes sent by the server: 3,636,653
--- total bytes send:
3,637,677
The protocol DRDA used by IBM DB2 is a more lean protocol compared to the ones used by Oracle and Microsoft.
If DRDA would be used with Oracle, the datastream
would be reduced by 41%.
If DRDA would be used with Microsoft SQL server, the datastream would be
reduced by 30%.
Harald Fuchs, HOB Germany
Klaus Brandstaetter, HOB Germany
Last Updated: 10. Nov 09 by webmaster@hob.de
|