BTW, there seem to be a room to enhance JDBC driver performance. In my understanding it always uses unnamed portal even if the SQL is like "BEGIN" or "COMMIT" (no parameters). They are too often used. Why not doing like this?
Prepare(stmt=S1,query="BEGIN") Bind(stmt=S1,portal=P1) Execute(portal=P1) : : Execute(portal=P1) : : Execute(portal=P1) Instead of: Prepare(stmt=S1,query="BEGIN") Bind(stmt=S1,portal=null) Execute(portal=null) : : Bind(stmt=s1,portal=null) Execute(portal=null) : : Bind(stmt=s1,portal=null) Execute(portal=null) This way, we could save bunch of Bind messages. I don't know what other drivers do though. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
