| From: | Michael Stephenson <mstephenson(at)tirin(dot)openworld(dot)co(dot)uk> |
|---|---|
| To: | PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] Re: [INTERFACES] Patch for JDBC timestamp problems |
| Date: | 2001-01-25 09:54:41 |
| Message-ID: | Pine.LNX.4.30.0101250949190.20707-100000@tirin.openworld.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-jdbc pgsql-patches |
On Wed, 24 Jan 2001, Joseph Shraibman wrote:
> > What was the conclusion of this discussion? Do we leave it static?
>
> No, it cannot be static.
As I see it we have three possible solutions to this problems.
a) Just stop it being static, each PreparedStatement gets a new
instantiation (I think this is what we've done for now).
b) static ThreadLocal, each Thread gets one instantiation.
c) An Object Pool (possibly using SoftReferences to stop memory bloat),
slightly more difficult to code, a lot less instantiations, much
better performance.
If people agree that either 'b' or 'c' is a better solution, I'll go ahead
and implement it.
Michael Stephenson mstephenson(at)openworld(dot)co(dot)uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2001-01-25 10:40:45 | RE: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows |
| Previous Message | clemens schmuck | 2001-01-25 08:26:52 | all groups a user belongs to |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Stephenson | 2001-01-25 10:25:59 | RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets |
| Previous Message | Peter T Mount | 2001-01-25 09:26:03 | Re: [GENERAL] jdbc driver, error trapping. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2001-01-25 11:23:27 | Yet another ODBC patch! |
| Previous Message | Hiroshi Inoue | 2001-01-25 06:02:11 | Re: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows |