3 ms·
The sqlite benchmark is not very optimised. Just adding: db.SetMaxOpenConns(runtime.NumCPU()) db.SetMaxIdleConns(runtime.NumCPU()) Made the performan
by WatchDog 6mo ago
The sqlite benchmark is not very optimised.
Just adding:
db.SetMaxOpenConns(runtime.NumCPU())
db.SetMaxIdleConns(runtime.NumCPU())
Made the performance on my machine go from 27,700.99 r/s to 89,687.36 r/s.
I also tried making the get user a prepared statement, and storing the timestamp as an unix timestamp integer, but that didn't make much difference for me.