postmodern-devel

Download

postmodern-devel@common-lisp.net

December 2010

4 participants
2 discussions

[postmodern-devel] Selecting schema with dao-class
by Slobodan Milnović 11 Dec '10

11 Dec '10

Hi, I'm trying to find any documentation about selecting database schema with dao-class, for example something like this: (defclass my-class () ((some-column :column t :accessor some-column :initarg some-column) ..... itd)) (:metaclass postmodern:dao-class) (:table-name (:dot 'scheme-name 'table-name)) (:keys some-column)) But it seems (:dot 'scheme-name 'table-name) format is supported only in queries? How can I select an schema in database?

2 2

[postmodern-devel] Minimum overhead per query
by Andy Chambers 09 Dec '10

09 Dec '10

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

3 2