Home > mailing lists

Fwd: A suggestion or a problem - Mailing list pgsql-jdbc

From	Dave Cramer
Subject	Fwd: A suggestion or a problem
Date	August 31, 2017 19:25:25
Msg-id	CADK3HHLouBESGaW=Lh=DUsf2zN9pV9U8NKc5RDdzaeKFy3Y2xQ@mail.gmail.com Whole thread Raw
List	pgsql-jdbc

Tree view

Dave Cramer

---------- Forwarded message ----------
From: fenglu@highgo.com <fenglu@highgo.com>
Date: 30 August 2017 at 23:41
Subject: A suggestion or a problem
To: pgsql-jdbc-owner <pgsql-jdbc-owner@postgresql.org>

Hi,

I have a problem when I learned about PGJDBC's source code.

When I closed a preparedStatement,PGJDBC driver will put the preparedQuery in the statementCache.When I perform the SQL again, the cache will remove it, and then if I don't have to perform the preparedStatement.close(), but the third time to perform the SQL, is it need to compile again leading to reduced performance?

Why not choose to set the cache to the LinkedHashMao type and set the maximum number ,use cache.get(key) and remove the least amount according to the SQL usage when the cache reaches its maximum value?