1 // Licensed to the Apache Software Foundation (ASF) under one
2 // or more contributor license agreements. See the NOTICE file
3 // distributed with this work for additional information
4 // regarding copyright ownership. The ASF licenses this file
5 // to you under the Apache License, Version 2.0 (the
6 // "License"); you may not use this file except in compliance
7 // with the License. You may obtain a copy of the License at
9 // http://www.apache.org/licenses/LICENSE-2.0
11 // Unless required by applicable law or agreed to in writing,
12 // software distributed under the License is distributed on an
13 // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
14 // KIND, either express or implied. See the License for the
15 // specific language governing permissions and limitations
18 // Alternatively, use bundles for performance tests
19 // import * as Arrow from '../targets/es5/umd';
20 // import * as Arrow from '../targets/es5/cjs';
21 // import * as Arrow from '../targets/es2015/umd';
22 // import * as Arrow from '../targets/es2015/cjs';
24 import * as Arrow from '../src/Arrow';
26 import config from './config';
27 import b from 'benny';
28 import { CaseResult, Summary } from 'benny/lib/internal/common-types';
29 import kleur from 'kleur';
31 const { predicate, Table, RecordBatchReader } = Arrow;
32 const { col } = predicate;
35 const args = process.argv.slice(2);
36 const json = args[0] === '--json';
38 const formatter = new Intl.NumberFormat();
39 function formatNumber(number: number, precision = 0) {
40 const rounded = number > precision * 10 ? Math.round(number) : parseFloat((number).toPrecision(precision));
41 return formatter.format(rounded);
44 const results: CaseResult[] = [];
46 function cycle(result: CaseResult, _summary: Summary) {
47 const duration = result.details.median * 1000;
49 result.suite = _summary.name;
53 `${kleur.cyan(result.name)} ${formatNumber(result.ops, 3)} ops/s ±${result.margin.toPrecision(2)}%, ${formatNumber(duration, 2)} ms, ${kleur.gray(result.samples + ' samples')}`,
57 for (const { name, ipc, df } of config) {
61 b.add(`dataset: ${name}, function: Table.from`, () => {
65 b.add(`dataset: ${name}, function: readBatches`, () => {
66 for (const _recordBatch of RecordBatchReader.from(ipc)) {}
69 b.add(`dataset: ${name}, function: serialize`, () => {
76 const schema = df.schema;
79 suite_name: `Get values by index`,
80 fn(vector: Arrow.Column<any>) {
81 for (let i = -1, n = vector.length; ++i < n;) {
86 suite_name: `Iterate vectors`,
87 fn(vector: Arrow.Column<any>) { for (const _value of vector) {} }
89 suite_name: `Slice toArray vectors`,
90 fn(vector: Arrow.Column<any>) { vector.slice().toArray(); }
92 suite_name: `Slice vectors`,
93 fn(vector: Arrow.Column<any>) { vector.slice(); }
96 for (const {suite_name, fn} of suites) {
100 ...schema.fields.map((f, i) => {
101 const vector = df.getColumnAt(i)!;
102 return b.add(`dataset: ${name}, column: ${f.name}, length: ${formatNumber(vector.length)}, type: ${vector.type}`, () => {
113 for (const { name, df, countBys, counts } of config) {
117 b.add(`dataset: ${name}, length: ${formatNumber(df.length)}`, () => {
118 for (const _value of df) {}
125 `DataFrame Count By`,
127 ...countBys.map((column: string) => b.add(
128 `dataset: ${name}, column: ${column}, length: ${formatNumber(df.length)}, type: ${df.schema.fields.find((c)=> c.name === column)!.type}`,
129 () => df.countBy(column)
136 `DataFrame Filter-Scan Count`,
138 ...counts.map(({ column, test, value }: {column: string; test: 'gt' | 'eq'; value: number | string}) => b.add(
139 `dataset: ${name}, column: ${column}, length: ${formatNumber(df.length)}, type: ${df.schema.fields.find((c)=> c.name === column)!.type}, test: ${test}, value: ${value}`,
141 let filteredDf: Arrow.FilteredDataFrame;
143 filteredDf = df.filter(col(column).gt(value));
144 } else if (test == 'eq') {
145 filteredDf = df.filter(col(column).eq(value));
147 throw new Error(`Unrecognized test "${test}"`);
150 return () => filteredDf.count();
158 `DataFrame Filter-Iterate`,
160 ...counts.map(({ column, test, value }: {column: string; test: 'gt' | 'eq'; value: number | string}) => b.add(
161 `dataset: ${name}, column: ${column}, length: ${formatNumber(df.length)}, type: ${df.schema.fields.find((c)=> c.name === column)!.type}, test: ${test}, value: ${value}`,
163 let filteredDf: Arrow.FilteredDataFrame;
165 filteredDf = df.filter(col(column).gt(value));
166 } else if (test == 'eq') {
167 filteredDf = df.filter(col(column).eq(value));
169 throw new Error(`Unrecognized test "${test}"`);
173 for (const _value of filteredDf) {}
182 `DataFrame Direct Count`,
184 ...counts.map(({ column, test, value }: {column: string; test: 'gt' | 'eq'; value: number | string}) => b.add(
185 `dataset: ${name}, column: ${column}, length: ${formatNumber(df.length)}, type: ${df.schema.fields.find((c)=> c.name === column)!.type}, test: ${test}, value: ${value}`,
187 const colidx = df.schema.fields.findIndex((c)=> c.name === column);
192 const batches = df.chunks;
193 const numBatches = batches.length;
194 for (let batchIndex = -1; ++batchIndex < numBatches;) {
196 const batch = batches[batchIndex];
197 const vector = batch.getChildAt(colidx)!;
199 for (let index = -1, length = batch.length; ++index < length;) {
200 sum += (vector.get(index) >= value) ? 1 : 0;
205 } else if (test == 'eq') {
208 const batches = df.chunks;
209 const numBatches = batches.length;
210 for (let batchIndex = -1; ++batchIndex < numBatches;) {
212 const batch = batches[batchIndex];
213 const vector = batch.getChildAt(colidx)!;
215 for (let index = -1, length = batch.length; ++index < length;) {
216 sum += (vector.get(index) === value) ? 1 : 0;
222 throw new Error(`Unrecognized test "${test}"`);
230 // last benchmark finished
231 json && process.stderr.write(JSON.stringify(results, null, 2));