Skip to content

Instantly share code, notes, and snippets.

@284km
Created May 31, 2018 07:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 284km/460b2098660a47abf21aa4878a00af8e to your computer and use it in GitHub Desktop.
Save 284km/460b2098660a47abf21aa4878a00af8e to your computer and use it in GitHub Desktop.
libcsv/csv ips
# 5 columns, 10,000 rows

Warming up --------------------------------------
            unquoted     1.000  i/100ms
              quoted     1.000  i/100ms
   (libcsv) unquoted     1.000  i/100ms
     (libcsv) quoted     1.000  i/100ms
Calculating -------------------------------------
            unquoted     15.828  (± 6.3%) i/s -     79.000  in   5.041254s
              quoted      9.565  (±20.9%) i/s -     46.000  in   5.062622s
   (libcsv) unquoted     15.987  (± 6.3%) i/s -     80.000  in   5.042159s
     (libcsv) quoted     14.484  (± 6.9%) i/s -     72.000  in   5.007109s

Comparison:
   (libcsv) unquoted:       16.0 i/s
            unquoted:       15.8 i/s - same-ish: difference falls within error
     (libcsv) quoted:       14.5 i/s - same-ish: difference falls within error
              quoted:        9.6 i/s - 1.67x  slower

### 10 columns, 10,000 lines

Warming up --------------------------------------
            unquoted     1.000  i/100ms
              quoted     1.000  i/100ms
   (libcsv) unquoted     1.000  i/100ms
     (libcsv) quoted     1.000  i/100ms
Calculating -------------------------------------
            unquoted     12.661  (± 7.9%) i/s -     63.000  in   5.003322s
              quoted      6.966  (±14.4%) i/s -     35.000  in   5.055897s
   (libcsv) unquoted      6.320  (±15.8%) i/s -     32.000  in   5.138028s
     (libcsv) quoted      7.246  (± 0.0%) i/s -     37.000  in   5.129077s

Comparison:
            unquoted:       12.7 i/s
     (libcsv) quoted:        7.2 i/s - 1.75x  slower
              quoted:        7.0 i/s - 1.82x  slower
   (libcsv) unquoted:        6.3 i/s - 2.00x  slower

5 columns, 100,000 lines

Warming up --------------------------------------
            unquoted     1.000  i/100ms
              quoted     1.000  i/100ms
   (libcsv) unquoted     1.000  i/100ms
     (libcsv) quoted     1.000  i/100ms
Calculating -------------------------------------
            unquoted      1.400  (± 0.0%) i/s -      8.000  in   5.869580s
              quoted      0.943  (± 0.0%) i/s -      5.000  in   5.340503s
   (libcsv) unquoted      1.258  (± 0.0%) i/s -      7.000  in   5.627680s
     (libcsv) quoted      1.154  (± 0.0%) i/s -      6.000  in   5.244104s

Comparison:
            unquoted:        1.4 i/s
   (libcsv) unquoted:        1.3 i/s - 1.11x  slower
     (libcsv) quoted:        1.2 i/s - 1.21x  slower
              quoted:        0.9 i/s - 1.48x  slower

5 columns, 1,000 lines

Warming up --------------------------------------
            unquoted    15.000  i/100ms
              quoted    10.000  i/100ms
   (libcsv) unquoted    17.000  i/100ms
     (libcsv) quoted    17.000  i/100ms
Calculating -------------------------------------
            unquoted    162.239  (±11.1%) i/s -    810.000  in   5.083170s
              quoted    115.466  (± 6.9%) i/s -    580.000  in   5.054676s
   (libcsv) unquoted    176.517  (±11.9%) i/s -    867.000  in   5.026771s
     (libcsv) quoted    175.966  (± 7.4%) i/s -    884.000  in   5.053377s

Comparison:
   (libcsv) unquoted:      176.5 i/s
     (libcsv) quoted:      176.0 i/s - same-ish: difference falls within error
            unquoted:      162.2 i/s - same-ish: difference falls within error
              quoted:      115.5 i/s - 1.53x  slower

10 columns, 1,000 lines

Warming up --------------------------------------
            unquoted    12.000  i/100ms
              quoted     7.000  i/100ms
   (libcsv) unquoted     9.000  i/100ms
     (libcsv) quoted     9.000  i/100ms
Calculating -------------------------------------
            unquoted    130.284  (± 9.2%) i/s -    648.000  in   5.036978s
              quoted     75.772  (± 9.2%) i/s -    378.000  in   5.042339s
   (libcsv) unquoted     91.138  (± 7.7%) i/s -    459.000  in   5.066951s
     (libcsv) quoted     89.879  (± 8.9%) i/s -    450.000  in   5.057162s

Comparison:
            unquoted:      130.3 i/s
   (libcsv) unquoted:       91.1 i/s - 1.43x  slower
     (libcsv) quoted:       89.9 i/s - 1.45x  slower
              quoted:       75.8 i/s - 1.72x  slower

5 columns, 100 lines

Warming up --------------------------------------
            unquoted   147.000  i/100ms
              quoted   101.000  i/100ms
   (libcsv) unquoted   147.000  i/100ms
     (libcsv) quoted   145.000  i/100ms
Calculating -------------------------------------
            unquoted      1.416k (± 6.3%) i/s -      7.056k in   5.004110s
              quoted      1.031k (±10.4%) i/s -      5.151k in   5.079405s
   (libcsv) unquoted      1.513k (± 9.5%) i/s -      7.497k in   5.021599s
     (libcsv) quoted      1.552k (± 4.9%) i/s -      7.830k in   5.057735s

Comparison:
     (libcsv) quoted:     1552.1 i/s
   (libcsv) unquoted:     1513.0 i/s - same-ish: difference falls within error
            unquoted:     1416.2 i/s - same-ish: difference falls within error
              quoted:     1031.5 i/s - 1.50x  slower


10 columns, 100 lines

Warming up --------------------------------------
            unquoted   108.000  i/100ms
              quoted    66.000  i/100ms
   (libcsv) unquoted    86.000  i/100ms
     (libcsv) quoted    86.000  i/100ms
Calculating -------------------------------------
            unquoted      1.103k (± 6.8%) i/s -      5.508k in   5.016963s
              quoted    712.711  (± 5.5%) i/s -      3.564k in   5.016611s
   (libcsv) unquoted    918.455  (± 6.2%) i/s -      4.644k in   5.079549s
     (libcsv) quoted    920.616  (± 4.8%) i/s -      4.644k in   5.056843s

Comparison:
            unquoted:     1103.5 i/s
     (libcsv) quoted:      920.6 i/s - 1.20x  slower
   (libcsv) unquoted:      918.5 i/s - 1.20x  slower
              quoted:      712.7 i/s - 1.55x  slower






Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment