postmodern-devel December 2010

postmodern-devel@common-lisp.net

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

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

postmodern-devel December 2010