Fwd: A suggestion or a problem

Поиск

Список

Период

Сортировка

От	Dave Cramer
Тема	Fwd: A suggestion or a problem
Дата	31 августа 2017 г. 19:25:25
Msg-id	CADK3HHLouBESGaW=Lh=DUsf2zN9pV9U8NKc5RDdzaeKFy3Y2xQ@mail.gmail.com обсуждение исходный текст
Список	pgsql-jdbc

Дерево обсуждения

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?