Обсуждение: esql vs libpq
Hello, I'm doing a comparison between ESQL interfaces and libpq. For libp I use pgbench, based on TCP-C, while for ESQL have a program that also follows the transactions carried out on TCP-C. However, the result with libpq is much better, with about 700 transactions per second, whereas with ESQL does not reach the figure of 400. Does anyone know if libpq has superior performance to ESQL, or is there something I am not taking into account? Thanks
svcntk wrote: > I'm doing a comparison between ESQL interfaces and libpq. For libp I > use pgbench, based on TCP-C, while for ESQL have a program that also > follows the transactions carried out on TCP-C. > > However, the result with libpq is much better, with about 700 > transactions per second, whereas with ESQL does not reach the figure > of 400. Does anyone know if libpq has superior performance to ESQL, or > is there something I am not taking into account? What is ESQL? Yours, Laurenz Albe
svcntk wrote: > ESQL = ECPG (Embedded SQL in C) > >>> I'm doing a comparison between ESQL interfaces and libpq. For libp I >>> use pgbench, based on TCP-C, while for ESQL have a program that also >>> follows the transactions carried out on TCP-C. >>> >>> However, the result with libpq is much better, with about 700 >>> transactions per second, whereas with ESQL does not reach the figure >>> of 400. Does anyone know if libpq has superior performance to ESQL, or >>> is there something I am not taking into account? >> >> What is ESQL? I am to lazy to undo your top posting... For one thing, ecpg uses libpq, so it can hardly be more performant. For a more detailed analysis, you should compare what the test cases are actually doing. You could set log_statements='all' to see what arrives at the server, or you can use PQtrace (http://www.postgresql.org/docs/current/static/libpq-control.html) in your client code. Yours, Laurenz Albe
ESQL = ECPG (Embedded SQL in C) Thanks 2009/12/30 Albe Laurenz <laurenz.albe@wien.gv.at>: > svcntk wrote: >> I'm doing a comparison between ESQL interfaces and libpq. For libp I >> use pgbench, based on TCP-C, while for ESQL have a program that also >> follows the transactions carried out on TCP-C. >> >> However, the result with libpq is much better, with about 700 >> transactions per second, whereas with ESQL does not reach the figure >> of 400. Does anyone know if libpq has superior performance to ESQL, or >> is there something I am not taking into account? > > What is ESQL? > > Yours, > Laurenz Albe >