statement caching proof of concept

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: statement caching proof of concept
Date: 2006-06-19 16:55:46
Message-ID: 4077BF73-482B-46C8-B65D-2E1FD2465294@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

This is just proof of concept. More work has to be done to make it
build properly and work properly under different jdk's

Couple of questions.

1) What to do if there are multiple concurrent requests per
connection for the same statement?
1) we could just allow it
2) we could return a non-cacheable preparedstatement
3) throw an exception

2) Is it enough to cache prepared statements or should we cache
statements too?

Note: this work is based completely on apache's dbcp statement
caching implementation and this will be noted in the final code.

Attachment Content-Type Size
statementcache.diff application/octet-stream 8.4 KB
StatementPool.java application/octet-stream 2.2 KB
CacheConnection.java application/octet-stream 4.0 KB
CacheablePreparedStatement.java application/octet-stream 1.2 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message j.random.programmer 2006-06-19 17:38:58 Re: Meta Information about columns of a domain datatype ?
Previous Message Kris Jurka 2006-06-19 14:43:43 Re: Where can I get source for the 7.3 Build