Skip site navigation (1) Skip section navigation (2)

Re: Fastest way to check aliveness of connection

From: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Fastest way to check aliveness of connection
Date: 2008-02-27 07:57:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hello Oliver,

Oliver Jowett schrieb:
> Running an empty query ("") is probably the simplest way.
> In theory you could do something slightly faster at the protocol level 
> (just send Sync and wait for ReadyForQuery) but there's no interface 
> currently exposed to do that and I doubt that it will be much faster 
> than an empty query anyway.
Yes, I investigated that, but since the normal query procedure also just 
sends one package, the gain for just sending the sync does not really 
matter. Of course, your idea with the empty query is great. Thanks alot.

With best regards,
Daniel Migowski

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2008-02-29 16:59:17
Subject: Re: Array Char/VarChar Size
Previous:From: dmpDate: 2008-02-27 07:35:38
Subject: Array Char/VarChar Size

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group