> 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
in your client code.
In response to
pgsql-general by date
|Next:||From: Joshua Tolley||Date: 2009-12-30 11:42:55|
|Subject: Re: DataBase Problem|
|Previous:||From: Nicola Farina||Date: 2009-12-30 10:35:55|
|Subject: Out of memory problem|