Hacker News new | ask | show | jobs
by WatchDog 64 days 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.