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