Skip to content

Instantly share code, notes, and snippets.

View nmreadelf's full-sized avatar
🛠️
Coding

nmreadelf nmreadelf

🛠️
Coding
  • Singapore
  • 03:14 (UTC +08:00)
View GitHub Profile
@nmreadelf
nmreadelf / libchdb_cmd.sh
Created October 10, 2023 06:38
libchdb static
/usr/bin/clang++-15 --target=x86_64-linux-gnu --sysroot=/home/kongsys/repo/chdb/cmake/linux/../../contrib/sysroot/linux-x86_64/x86_64-linux-gnu/libc --gcc-toolchain=/home/kongsys/repo/chdb/cmake/linux/../../contrib/sysroot/linux-x86_64 -std=c++20 -fdiagnostics-color=always -fsized-deallocation -pipe -mssse3 -msse4.1 -msse4.2 -mpclmul -mpopcnt -mavx -mavx2 -fasynchronous-unwind-tables -ffile-prefix-map=/home/kongsys/repo/chdb=. -falign-functions=32 -mbranches-within-32B-boundaries -fPIC -fdiagnostics-absolute-paths -fstrict-vtable-pointers -DUSE_JEMALLOC=1 -Wl,-wrap,malloc -Wl,-wrap,valloc -Wl,-wrap,pvalloc -Wl,-wrap,calloc -Wl,-wrap,realloc -Wl,-wrap,memalign -Wl,-wrap,aligned_alloc -Wl,-wrap,posix_memalign -Wl,-wrap,free -DJEMALLOC_NO_RENAME=1 -DARROW_JEMALLOC=1 -Wall -Wextra -Wframe-larger-than=65536 -Weverything -Wpedantic -Wno-zero-length-array -Wno-c++98-compat-pedantic -Wno-c++98-compat -Wno-c++20-compat -Wno-sign-conversion -Wno-implicit-int-conversion -Wno-implicit-int-float-conversion -Wno-ctad-maybe
@nmreadelf
nmreadelf / c6a.4xlarge
Last active November 17, 2023 07:59
chdb 0.16.0 rc2
[0.14784930900009385,0.01985562499999105,0.021213920000036524],
[0.23510076200000185,0.06982731300013256,0.06856002199992872],
[0.2806472989998383,0.10366240700000162,0.10361096500014355],
[0.4541343600001255,0.10390106999989257,0.10059215999990556],
[0.6548878610001339,0.45662324699992496,0.44750324799997543],
[0.9521819659998982,0.6404522270001962,0.6559423100000004],
[0.19805788999997276,0.08715895099999216,0.0858150569999907],
[0.19715853299999253,0.07409634200007531,0.07549481599994579],
[0.8598950299999615,0.6492269000000306,0.6434426030000395],
[1.4808940620000612,0.7829620970001088,0.7904872159999741],
@nmreadelf
nmreadelf / a.ahk
Created August 19, 2024 05:48
take lc
^F7::
{
; open shop
MouseMove 355, 44
MouseClick "left"
Sleep 50
; choose consumables in shop
MouseMove 562, 588
MouseClick "left"
@nmreadelf
nmreadelf / input.html
Last active July 10, 2025 07:06
run env

first step new direcotry

install pip package

pip install "fastapi[standard]"

copy sample code to main.py

then run sample code

@nmreadelf
nmreadelf / benchmark_result.txt
Created May 10, 2026 11:52
2026-05-10 mfcthread
SRWLOCK 1 108.268
SRWLOCK 2 135.885
SRWLOCK 4 180.283
SRWLOCK 8 1974.561
SRWLOCK 12 5951.367
SRWLOCK 16 9221.044
SRWLOCK 24 12505.690
SRWLOCK 32 15860.819
SRWLOCK 48 30631.524
SRWLOCK 64 42405.439