Prerak Sanghvi prerak-proof

Query	MySQL/PostgreSQL	ClickHouse	DolphinDB	MemSQL
Load 35M trades	DNF (out of memory)	~32 sec	~6 sec	~80 sec
Load 719M quotes	DNF (out of memory)	~13 min	~11 min	~24 min
As-of join for SPY	-	1.3 sec	358 ms	52 sec
As-of join for all symbols	-	DNF (out of memory)	25 sec	1 h
VWAP by minute for all symbols	-	1.3 sec	5.7 sec	2 sec
OHLC minute bars for all symbols	-	1.7 sec	771 ms	3.9 sec
Time-weighted spread for all symbols	-	49 sec	23 sec	124 sec

	#!/bin/bash

	SYS_ROOT=/mnt/c/Proof
	WORK_ROOT=$SYS_ROOT/17a4-logs

	# log files
	CTIME=$(date "+%Y%m%d-%H%M%S")
	LOGFILE=$WORK_ROOT/${CTIME}.log.txt

	exec >> $LOGFILE 2>&1

	import jenkins.slaves.WorkspaceLocator
	workspaceRoot = WorkspaceLocator.all()[0].getWorkspaceRoot(Jenkins.get())

	processDir(workspaceRoot, Jenkins.instance)

	def processDir(rootDir, holder) {
	rootDir.list().each { dir ->
	deleteIfInvalid(dir, holder.getItem(dir.name))
	}
	}

	processGroup(Jenkins.instance)

	def processGroup(itemGroup) {
	itemGroup.items.each { j ->
	if (j.class.simpleName == "Folder") {
	processGroup(j)
	} else {
	if (j.supportsLogRotator()) {
	j.setBuildDiscarder(new hudson.tasks.LogRotator(365, 30, 365, 30))
	println(j)

	alias cleangit='git branch --merged=master \| grep -v "master$" \| xargs -r git branch -d'

	function gitmaster() {
	git fetch -p \|\| return 1
	git --no-pager log --oneline master..origin/master
	git pull --rebase origin master:master \|\| return 1
	git checkout master \|\| return 1
	cleangit
	}

	import hudson.tasks.*
	import hudson.plugins.ws_cleanup.*

	processGroup(Jenkins.instance)

	def processGroup(itemGroup) {
	for(item in itemGroup.items) {
	if (item.class.simpleName == "Folder") {
	processGroup(item)
	} else {