Evaluate Profile-Guided Optimization (PGO) and LLVM BOLT

[zamazan4ik]

Hi!

Recently I checked Profile-Guided Optimization (PGO) improvements on multiple projects. The results are here. Since PGO shows improvements for many workloads (including many databases like SQLite), I think trying to optimize TerminusDB with PGO can be a good idea.

I can suggest the following action points:

• Perform PGO benchmarks on TerminusDB. And if it shows improvements - add a note about possible improvements in TerminusDB's performance with PGO. Even if the database is a library, it's still important for the users to understand the benefits for TerminusDB performance from PGO.

Here you can find examples of how PGO (and sometimes LLVM BOLT) is already integrated into different projects. Here are the documentation examples with PGO in different projects.

Maybe testing Post-Link Optimization techniques (like LLVM BOLT) would be interesting too but I recommend starting from the usual PGO.

For the Rust projects, I suggest PGO optimizing with cargo-pgo (it supports LLVM BOLT too).