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?
Cheers, Andy
"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
100 ms overhead for a tiny query sounds very wrong. I just tried this out as well -- (time (query (:select 1))) -- and am seeing about .8 milliseconds average. If such a query from another tool is also taking 120ms, I think you should look for the problem in your server, since this shouldn't be taking that long, not even on 1990-era hardware.
Best, Marijn
postmodern-devel@common-lisp.net
-
Andy Chambers -
Marijn Haverbeke -
Zach Beane