develooper Front page | perl.perl5.porters | Postings from May 2016

Speed compare

Thread Next
From:
H.Merijn Brand
Date:
May 12, 2016 11:21
Subject:
Speed compare
Message ID:
20160512132102.5955384b@pc09.procura.nl
Using all available Hash-to-disk/db storage compare between 5.22.1 and 5.24.0

Higher numbers are better
Oracle is a remote machine on LAN

5.22.1

  Size op       GDBM       NDBM       ODBM       SDBM    DB_File   CDB_File   Berkeley      Redis     Redis2     SQLite         Pg      mysql        CSV     Oracle
------ -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
    20 rd    56338.0   101010.1    93457.9   111731.8    75188.0   333333.3    40733.2     1927.0     7657.0    22421.5     2750.3     1388.1      628.4       50.5
    20 wr    62500.0    11540.7    13840.8    11474.5    15885.6     7725.0    11757.8     1380.8     5793.7     8240.6      980.4      312.6      614.8       39.8
   200 rd    91240.9   112170.5    54990.4   133244.5    38669.8   373134.3    47835.4     4481.2     8249.5    31923.4     5195.6     1024.4      146.6          -
   200 wr   171232.9    60042.0    33551.4    52631.6    27777.8    61614.3    45955.9     2982.2     9547.0    20044.1     2332.1      769.3      273.2          -
   600 rd    75862.9   126448.9    73682.9   139599.8    48721.1   473559.6    48594.8     5676.9     8330.9    36939.0     7609.2      722.6          -          -
   600 wr    87463.6   100908.2    59265.1    70821.5    46663.6   117739.4    57427.3     4600.6    10235.9    25373.2     4217.8      560.1          -          -
  2000 rd   109673.2   122872.8    93576.0   128518.2    65108.4   484496.1    76213.7     8254.0     8273.0    44895.4     7618.2      250.5          -          -
  2000 wr    99290.1   118336.2    80137.8    79728.9    68563.6   255102.0    93958.5    10234.5    10193.1    32137.3     5377.7      305.5          -          -
 20000 rd   220085.0   131104.6   126438.2   132735.1    92341.6   605932.1    69736.0     7749.9     8044.7    42515.1     8459.2          -          -          -
 20000 wr   134848.1   121626.4   119274.8   107127.2    83934.9   393043.1    69323.4    10005.1     9197.5    36231.6     5387.8          -          -          -
200000 rd   206688.2   163446.4   142222.8   133489.8    94910.8   602173.8    78426.6     8055.0     7785.3    36130.7     8526.9          -          -          -
200000 wr    86419.7    75698.1    76392.3   106588.2    57241.6   522952.4    48018.4     9798.7     9772.5    30455.6     5629.3          -          -          -

5.24.0

  Size op       GDBM       NDBM       ODBM       SDBM    DB_File   CDB_File   Berkeley      Redis     Redis2     SQLite         Pg      mysql        CSV     Oracle
------ -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
    20 rd    55555.6   114285.7    76045.6   120481.9    71428.6   327868.9    29368.6     2223.5     7782.1    31545.7     4640.4     1384.8      874.9       51.3
    20 wr    51679.6     8795.1     5745.5     7870.9     9263.5     4929.8     4732.6     1420.2     5153.3     8006.4     1303.8      306.5      864.0       32.6
   200 rd    71916.6    58979.7    92635.5   133958.5    82304.5   386100.4    38255.5     3940.7     8480.7    44345.9     4491.0     1349.6      148.8          -
   200 wr    72176.1    23972.2    35868.0    41228.6    50607.3    36893.6    26917.9     3439.0     9103.7    26957.8     3013.7      732.9      295.1          -
   600 rd    83252.4    81015.4   101044.1   139632.3    89753.2   427655.0    47311.1     7935.4     6598.0    48023.1     7999.5      578.7          -          -
   600 wr    87912.1    57284.7    60802.6    61887.6    79713.0    95435.0    42143.7     7757.8    10098.5    31719.2     3130.9      567.1          -          -
  2000 rd   126047.8   101693.2   108412.8   132687.6    91320.0   465116.3    57308.2     8372.9     8414.7    46825.2    10952.8      257.6          -          -
  2000 wr   104794.3    80080.1    87642.4    75895.6    95556.6   200984.8    57250.8    10234.9     9905.4    34756.0     6644.3      324.2          -          -
 20000 rd   222377.9   131835.7   130637.8   141820.8    85609.1   580871.9    74598.5     8303.9     8138.5    43025.0     8565.5          -          -          -
 20000 wr   130911.5   110024.3   107976.8   101310.5    83527.2   371195.2    67157.1    10019.3    10309.8    34752.5     5294.4          -          -          -
200000 rd   207462.6   162165.2   137609.7   144170.7   101671.0   566051.1    76821.4     8084.7     8120.8    36109.9     9223.3          -          -          -
200000 wr    80033.3    77232.4    73589.5   100249.1    56103.1   499273.6    49254.7     9889.6     9965.8    27869.9     5855.2          -          -          -



-- 
H.Merijn Brand  http://tux.nl   Perl Monger  http://amsterdam.pm.org/
using perl5.00307 .. 5.23   porting perl5 on HP-UX, AIX, and openSUSE
http://mirrors.develooper.com/hpux/        http://www.test-smoke.org/
http://qa.perl.org   http://www.goldmark.org/jeff/stupid-disclaimers/

Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About