Skip to content

Instantly share code, notes, and snippets.

View gvenzl's full-sized avatar
🚀

Gerald Venzl gvenzl

🚀
View GitHub Profile
@gvenzl
gvenzl / sqlcl.sh
Last active February 1, 2023 18:11 — forked from krisrice/sqlcl.sh
sql() {
# REMOTE source this script
#
# . <(curl -s https://gist.githubusercontent.com/krisrice/fec43fd9f53e4286e5cc360b554e3c0f/raw/62ec382d7511c7cc44703a9a2f75a4a7f233efe2/sqlcl.sh)
# Set the stage directory
STAGE_DIR=/var/tmp
# Check whether internet connection exists
if ping -c 1 -W 3 download.oracle.com > /dev/null; then
@gvenzl
gvenzl / latency.txt
Created August 7, 2019 17:32 — forked from jboner/latency.txt
Latency Numbers Every Programmer Should Know
Latency Comparison Numbers (~2012)
----------------------------------
L1 cache reference 0.5 ns
Branch mispredict 5 ns
L2 cache reference 7 ns 14x L1 cache
Mutex lock/unlock 25 ns
Main memory reference 100 ns 20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy 3,000 ns 3 us
Send 1K bytes over 1 Gbps network 10,000 ns 10 us
Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD