9 Dec
2010
9 Dec
'10
5:05 p.m.
"Andy Chambers" achambers@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