Make your own free website on Tripod.com

HOME Performance Installation Download Author

     Performance

    JDBC drivers comparison

    The check of productivity was carried out for various OS and various JDBC of drivers was gathered using the program " JBench (Copyright 1999 OpenLink Software) " (I have received it with Trail version of OpenLink JDBC driver).

First test:

  • Server: Sun SPARCStation-20 CPU 2X150Mhz HyperSparc; RAM 256 Mb; Solaris 2.5.1
  • Database: OpenIngres 2.0
  • Client: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5; IBM JDK 1.1.7

For the stored procedures bench the following procedure was used:

-----------------------< cut  >---------------------------------------
create procedure ODBC_BENCHMARK(
        vhistid = i4 with null,
        acct    = i4 with null,
        vteller = i4 with null,
        vbranch = i4 with null,
        delta   = float8 with null, 
        balance = float8 with null,
        vfiller = varchar(20) with null) as
begin
update account set balance = balance + :delta where account = :acct;

select :balance = balance from account where account = :acct;

update teller set balance = balance + :delta where teller = :vteller;

update branch set balance = balance + :delta where branch = :vbranch;

insert INTO history
        (histid, account, teller, branch, amount, timeoftxn, filler)
values
        (:vhistid, :acct, :vteller, :vbranch, :delta, date('today'), :vfiller);
end;
-----------------------< cut  >---------------------------------------
 
          

Boeireep Database Driver version 1.10.0005

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 179.628 1265 7.04233193 100 0 0 0.141998 0.6309999999981812
Prepare-Execute 179.538 1372 7.641836269 100 0 0 0.130859 0.5509999999969466
Stored proc 178.055 3722 20.90365337 100 0 0 0.047839 1.953999999999894
SQL execute/Query 179.628 713 3.969314361 100 0 0 0.251933 0.3910000000002185
Prepare-Execute/Query 179.518 749 4.172283559 100 0 0 0.239677 0.511000000000223
Stored proc/Query 179.015 1110 6.200597715 100 0 0 0.161275 1.0639999999997372
SQL execute/Txn 179.669 1706 9.495238466 100 0 0 0.105316 0.37999999999829015
Prepare-Execute/Txn 179.509 1583 8.818499351 100 0 0 0.113398 0.5800000000020873
Stored proc/Txn 178.838 3451 19.29679375 100 0 0 0.051822 1.1709999999987133
SQL execute/Txn/Query 179.887 828 4.602889592 100 0 0 0.217255 0.2820000000005507
Prepare-Execute/Txn/Query 179.698 794 4.418524413 100 0 0 0.22632 0.3800000000008481
Stored proc/Txn/Query 179.398 1099 6.126043769 100 0 0 0.163237 0.7109999999997569

Merant Sequelink JDBC Driver 4.5.00

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 179.707 1127 6.271319426 100 0 0 0.159456 0.40200000000055525
Prepare-Execute 179.618 1135 6.318965805 100 0 0 0.158254 0.6110000000016385
Stored proc                
SQL execute/Query 179.899 582 3.235148611 100 0 0 0.309105 0.2700000000002092
Prepare-Execute/Query 180.099 628 3.486971055 100 0 0 0.286782 0.27100000000010027
Stored proc/Query                
SQL execute/Txn 179.618 1522 8.473538287 100 0 0 0.118014 0.381000000000256
Prepare-Execute/Txn 179.237 1607 8.965782735 100 0 0 0.111535 0.6910000000008836
Stored proc/Txn                
SQL execute/Txn/Query 179.698 733 4.079065988 99 0 0 0.245154 0.3109999999998081
Prepare-Execute/Txn/Query 179.649 738 4.108010621 100 0 0 0.243427 0.32000000000033424
Stored proc/Txn/Query                

CaribouLake JSQL Driver version 3.4.5

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 179.248 175 0.976300991 5 94 0 1.024274 1.0709999999997422
Prepare-Execute 179.657 178 0.990776869 9 90 0 1.009309 2.013999999999726
Stored proc                
SQL execute/Query 179.728 153 0.851286388 0 99 0 1.174693 1.0410000000001105
Prepare-Execute/Query 179.918 157 0.872619749 0 100 0 1.145975 2.1340000000000714
Stored proc/Query                
SQL execute/Txn 179.959 147 0.816852728 0 100 0 1.224211 1.2610000000001378
Prepare-Execute/Txn 179.469 147 0.819082961 0 100 0 1.220878 2.1020000000001176
Stored proc/Txn                
SQL execute/Txn/Query 179.539 130 0.724076663 0 98 1 1.381069 1.031000000000148
Prepare-Execute/Txn/Query 180.28 132 0.732194364 0 100 0 1.365758 2.1030000000001507
Stored proc/Txn/Query                

 

 

Second test:

  • Server: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5
  • Database: Ingres II
  • Client: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5; IBM JDK 1.1.7

CA-ODBC driver version 2.8 patch 6435 through JDBC-ODBC gateway

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 170.842 2438 14.2705 100 0 0 0.070075 9.137
Prepare-Execute 125.734 1468 11.67544 100 0 0 0.08565 54.205
Stored proc                
SQL execute/Query 177.425 927 5.224743 100 0 0 0.191397 2.664
Prepare-Execute/Query 144.094 716 4.968979 100 0 0 0.201249 35.885
Stored proc/Query                
SQL execute/Txn 170.402 2809 16.48455 100 0 0 0.060663 9.637
Prepare-Execute/Txn 86.251 1354 15.69837 100 0 0 0.063701 93.087
Stored proc/Txn                
SQL execute/Txn/Query 172.208 1057 6.137926 100 0 0 0.162921 7.982
Prepare-Execute/Txn/Query 120.719 650 5.384405 100 0 0 0.185722 59.901
Stored proc/Txn/Query                

Boeireep Database Driver version 1.10.0005

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 171.405 2536 14.79537 100 0 0 0.067589 8.583
Prepare-Execute 169.223 2853 16.85941 100 0 0 0.059314 10.696
Stored proc 157.254 6925 44.03704 100 0 0 0.022708 22.665
SQL execute/Query 173.416 1598 9.214836 100 0 0 0.1085206508 6.563
Prepare-Execute/Query 173.83 1739 10.00403 100 0 0 0.09996 5.948
Stored proc/Query 171.206 2678 15.64198 100 0 0 0.063931 8.602
SQL execute/Txn 170.25 2857 16.7812 100 0 0 0.05959 9.518
Prepare-Execute/Txn 170.726 2639 15.45752 100 0 0 0.064693 9.233
Stored proc/Txn 158.407 6943 43.83013 100 0 0 0.022815 21.532
SQL execute/Txn/Query 173.741 1767 10.17031 100 0 0 0.098325 6.057
Prepare-Execute/Txn/Query 173.701 1684 9.69482 100 0 0 0.103148 6.428
Stored proc/Txn/Query 171.383 2692 15.70751 100 0 0 0.063664 8.586

CaribouLake JSQL Driver version 3.4.5

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 179.569 2466 13.73288 100 0 0 0.072818 0.43
Prepare-Execute 178.298 2680 15.03102 100 0 0 0.066529 1.591
Stored proc                
SQL execute/Query 179.108 1678 9.368649 100 0 0 0.106739 0.87
Prepare-Execute/Query 178.833 1780 9.95342 100 0 0 0.100468 1.176
Stored proc/Query                
SQL execute/Txn 179.498 2719 15.1478 100 0 0 0.066016 0.461
Prepare-Execute/Txn 178.657 2412 13.50073 100 0 0 0.07407 1.291
Stored proc/Txn                
SQL execute/Txn/Query 179.518 1826 10.17168 100 0 0 0.098312 0.471
Prepare-Execute/Txn/Query 179.258 1683 9.388702 100 0 0 0.106511 0.801
Stored proc/Txn/Query                

Merant Sequelink JDBC driver version 4.5.00

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 172.577 2014 11.67015 100 0 0 0.085689 7.512
Prepare-Execute 171.537 2117 12.34136 100 0 0 0.081028 8.352
Stored proc                
SQL execute/Query 174.92 1386 7.923622 100 0 0 0.126205 5.149
Prepare-Execute/Query 173.854 1432 8.236796 100 0 0 0.121406 6.124
Stored proc/Query                
SQL execute/Txn 172.728 2377 13.76152 100 0 0 0.072666 7.672
Prepare-Execute/Txn 171.256 2497 14.58051 100 0 0 0.068585 8.743
Stored proc/Txn                
SQL execute/Txn/Query 173.758 1580 9.093107 100 0 0 0.109973 6.261
Prepare-Execute/Txn/Query 174.962 1626 9.293447 100 0 0 0.107603 5.117
Stored proc/Txn/Query                

 

 

Third test:

  • Server: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5
  • Database: Ingres II
  • Client: Sun SPARCStation-20 CPU 2X150Mhz HyperSparc; RAM 256 Mb; Solaris 2.5.1; SUN JDK 1.1.8

Boeireep Database Driver version 1.10.0005

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 177.438 2052 11.5646 100 0 0 0.086471 2.5
Prepare-Execute 177.194 2351 13.26794 99 0 0 0.07537 2.87
Stored proc Stored proc 166.387 6326 38.0198 100 0 0 0.026302 13.549
SQL execute/Query 179.364 943 5.257465 100 0 0 0.190206 0.618
Prepare-Execute/Query 178.683 1056 5.909907 100 0 0 0.169207 1.463
Stored proc/Query 177.985 1432 8.045622 99 0 0 0.124291 1.919
SQL execute/Txn 177.221 2304 13.00072 100 0 0 0.076919 2.739
Prepare-Execute/Txn 177.683 2286 12.86561 100 0 0 0.077727 2.249
Stored proc/Txn 171.541 6640 38.70795 100 0 0 0.025834 8.341
SQL execute/Txn/Query 179.293 1079 6.018082 100 0 0 0.166166 0.597
Prepare-Execute/Txn/Query 178.57 1082 6.059248 100 0 0 0.165037 1.38
Stored proc/Txn/Query 178.024 1553 8.723543 100 0 0 0.114632 1.902

CaribouLake JSQL Driver version 3.4.5

SQL Options used Transaction time Total transactions Transactions per second % less than 1 second % 1 < n < 2 seconds % more than 2 seconds Average processing time Environmental overhead for the run
SQL execute 178.045 1733 9.733494 100 0 0 0.102738 1.907
Prepare-Execute 178.236 1896 10.63758 100 0 0 0.094006 1.745
Stored proc                
SQL execute/Query 178.711 994 5.562053 100 0 0 0.17979 1.383
Prepare-Execute/Query 178.644 1056 5.911198 100 0 0 0.16917 1.253
Stored proc/Query                
SQL execute/Txn 178.975 1824 10.19137 100 0 0 0.098122 0.972
Prepare-Execute/Txn 178.635 1745 9.768522 100 0 0 0.10237 1.385
Stored proc/Txn                
SQL execute/Txn/Query 179.287 1058 5.901153 100 0 0 0.169458 0.7
Prepare-Execute/Txn/Query 178.75 1019 5.700699 100 0 0 0.175417 1.192
Stored proc/Txn/Query                

    ODBC drivers comparison

    It will be later...

    The check of productivity was carried out for various OS and various ODBC of drivers was gathered using the program " Inside ODBC Benchmark (Copyright 1994-1995 Microsoft Software) " (I have received it with Trail version of OpenLink ODBC driver).

First test:     It will be later...

  • Server: Sun SPARCStation-20 CPU 2X150Mhz HyperSparc; RAM 256 Mb; Solaris 2.5.1
  • Database: OpenIngres 1.1
  • Client: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5

 

 

Second test:     It will be later...

  • Server: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5
  • Database: Ingres II
  • Client: PC CPU PII-366Mhz; RAM 64Mb; WindowsNT SP5

 

 

   Please, send your comments to:   Sergei Malinin

 


HOME Performance Installation Download Author