Re: measure of JDBC performances

Hello,

On which server platform are you using postgres? Are you using the
JDBC driver of postgres or the JDBC-ODBC driver?

Frederic

> -----Original Message-----
> From: Auri Mason [mailto:amason(at)syntrex(dot)com]
> Sent: Wednesday, March 13, 2002 9:18 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] measure of JDBC performances
>
>
> Hi to all,
>
> This is my first msg in this list and I hope it isn't OT...
>
> I've a java server application that accecc a database using a JDBC
> driver.
> Due to compare the postgres performances I made two tests
> with the same
> java server using MS Sql 2000 and Postgres 7.2 as database.
> The test reports a time 3 or 4 time longer when using postgres.
> How can I investigate if the bottleneck is the driver or the database?
>
> My first idea is a measure of query execution time with psql
> and via JDBC;
> how can I do that?
>
> TIA, Auri
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>