Re: JDBC Overhead - Mailing list pgsql-jdbc

From John R Pierce
Subject Re: JDBC Overhead
Date
Msg-id 44CFF46E.4000803@hogranch.com
Whole thread Raw
In response to JDBC Overhead  ("Bob Damato" <bob_damato@coxtarget.com>)
List pgsql-jdbc
> When I run this same code against a mySQL or Sybase database, I get
> 1ms execution time. Am I missing some bit of tuning that I can do with
> the database or the JDBC driver to eliminate that 50+ms of latency?
>


What do you get when you execute (from a shell prompt, assuming you're
on a unix type system),

    $ time psql -c "SELECT 1;"  dbname username

unluckily, this won't work if password authentication is required,
unless you setup a ~/.pgpass

I get about 12mS on a several year old x86 linux server



pgsql-jdbc by date:

Previous
From: "Bob Damato"
Date:
Subject: JDBC Overhead
Next
From: Dave Cramer
Date:
Subject: Re: JDBC Overhead