Re: JDBC Overhead

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Bob Damato <bob_damato(at)coxtarget(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC Overhead
Date: 2006-08-02 00:40:14
Message-ID: 44CFF46E.4000803@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-08-02 00:53:07 Re: JDBC Overhead
Previous Message Bob Damato 2006-08-01 20:05:38 JDBC Overhead