Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Has performance been evaluated? #38

Open
bayueqiankong opened this issue Apr 3, 2023 · 2 comments
Open

Has performance been evaluated? #38

bayueqiankong opened this issue Apr 3, 2023 · 2 comments

Comments

@bayueqiankong
Copy link

bayueqiankong commented Apr 3, 2023

Have you compared with other c++ libraries for postgresql?
Such as,libpqxx (it has not connection pool)

@dmitigr
Copy link
Owner

dmitigr commented Apr 3, 2023

Hey! I've compared with native libpq. The difference is around 11%.
Please note, there are also another useful features like named parameters in prepared statements and convenient database function invoking which may lacks in other client libraries.

@ddevienne
Copy link

Just curious, have you some kind of standard set of benchmarks for PostgreSQL clients?
I have my own home grown libpq wrapper as well, proprietary though, and would like to compare against yours and others.
Also, there are many areas in libpq:

  • text vs binary mode.
  • unprepared vs prepared statements, with binds
  • statements vs cursors vs copy
  • small columns vs toast vs lo
  • regular vs pipeline mode (new in libpq v14)
  • lots of small queries / transactions, vs big multi-MB/GB transactions (my use-cases does both)
  • windows (msvc) vs linux (gcc or clang)
  • etc...

Just saying 11% overhead is not saying much :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants