Evaluate using Profile-Guided Optimization (PGO) for Prisma

[zamazan4ik]

Hi!

Recently I did many Profile-Guided Optimization (PGO) benchmarks on multiple projects (including many databases like PostgreSQL, ClickHouse, Redis, MongoDB, etc.) - the results are available here. According to my tests, PGO helps with optimizing performance for many applications in different software domains. I think it can be interesting trying to apply PGO to Prisma libraries and measure the performance improvement from PGO.

I can suggest the following things to do:

• Evaluate PGO on Prisma.
• If PGO helps to achieve better performance - add a note to Prisma's documentation about that. In this case, users and maintainers will be aware of another optimization opportunity for Prisma.
• Provide PGO integration into the build scripts. It can help users and maintainers easily apply PGO for their workloads.
• Optimize prebuilt binaries with PGO if you will be able to figure out a "typical" workload.

PGO can be enabled for both standalone binaries and libraries. For starting with PGO for Rust projects I can recommend using cargo-pgo tool. However, you also can use PGO-related compiler flags directly.

P.S. Please do not treat the issue as a bug or smth like that - I just created it since Discussions are disabled for the repository. It's just an idea how Prisma's performance can be improved.