Re: JDBC Overhead

> 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