[postmodern-devel] Minimum overhead per query

[Zach Beane]

"Andy Chambers" <achambers at mcna.net> writes:

> Hi,
>
> We're finding that even very simple queries (e.g. "select 1;") take around  
> 220ms to return a result.  The same query is reported as taking ~120ms on  
> pgAdmin which suggests a postmodern overhead of around 100ms per query.   
> Does this sound right to others on the list?  Is there any way to reduce  
> this overhead for applications that may generate lots of small simple  
> queries?

Doesn't sound right to me. I'm connecting to a Postgres server on the
local network. (postmodern:query "select 1") returns in 1ms with the
expected answer. Are you including the time to establish a connection,
or something?

Zach