[zamazan4ik]

If you are interested in optimizing the project further, I can suggest you rebuilding SQLite with Profile-Guided Optimization (PGO). I collected as many as possible materials (including many related benchmarks) in my repo: https://github.com/zamazan4ik/awesome-pgo . Regarding SQLite and PGO, I have the following link: https://sqlite.org/forum/forumpost/19870fae957d8c1a

[jtarchie]

I have not tried that.

Will PGO work with CGO external libraries? I'm using https://github.com/mattn/go-sqlite3

[bomewish]

Have you tested PGO for FTS in SQLite? It wasn’t clear from all those links. Would be very interested in that.

[zamazan4ik]

Nope, I didn't test PGO explicitly on its FTS functionality. However, I am 99% sure that by enabling PGO for FTS you can expect ~5-10% performance win too.