phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject how to clear statement cache
Date Sun, 09 Mar 2014 17:16:40 GMT
Are you doing a statement.close() for each statement?

On Saturday, March 8, 2014, alex kamil
<alex.kamil@gmail.com<javascript:_e(%7B%7D,'cvml','alex.kamil@gmail.com');>>
wrote:

> if I reuse PhoenixConnection to upsert a few million rows via
> PreparedStatement the statements seem to be cached by the JDBC driver, and
> it uses most of the available heap  until the client runs out of memory and
> starts FullGC-ing to no avail
> does phoenix JDBC driver allow to clear statement cache (as
> clearStatementCache<http://docs.oracle.com/cd/E11035_01/wls100/jdbc_admin/manage.html#wp1048073>
in
> webLogic)
> I don't want to tear down and reestablish the connection on each upsert as
> it would introduce latency
>
> Thanks
>
> Alex
>

Mime
View raw message