Evaluate Profile-Guided Optimization (PGO) #345
Description
Hi.
There are a lot of examples of different software, where Profile-Guided Optimization (PGO) helps a lot with performance - you can check it here. E.g. in this list are a lot of databases like Redis, MongoDB, and PostgreSQL. For CR-SQLite the most interesting results I think the PGO results for SQLite.
We need to check the PGO effects on cr-sqlite, and if it works well - write a note in the cr-sqlite documentation about PGO (like it's already done for ClickHouse). I'd appreciate your providing an easy way to build cr-sqlite with PGO, and experienced users will be able to do it on their own for their own usage scenarios. Another option is to optimize the cr-sqlite builds with a generic-enough profile. Providing PGO-optimized binaries could be a trickier task (since it requires preparing a good-enough profile) but as an option would be great to see too.
For the Rust projects, I recommend starting with cargo-pgo.